Hi
I stopped using free tables and went to DBC quite a few years back. (think when
I moved from CA-Clipper to Fox)
Anything that needs to be more resilient I convert to SQL Server and use Cursor
Adapters or SQLExec.
Certainly when I've had to free a table the long field names are the biggest
headache because it means so many code and report changes and then serious
testing. Hence the reason I avoid doing this.
May I ask what issues do you get with DBC or is it a preference thing.
Depending how many tables/fields I would probably write a convert proc to do
this so something like
for each table
for each record in table
append record from old to new with scatter/gather shortening any fields
long than 10.
Possibly echoing out each variable long than 10. I suppose it would then be
feasible to open each scx, frx, and vcx looking for these fields and replacing
them with the new names.
Just a thought.
________________________________
From: ProFox on behalf of James Harvey
Sent: Mon 08/07/2013 13:45
To: 'ProFox Email List'
Subject: Fee tables from DBC
I think I've finally decided to stop using a DBC, and would like to revert
back to a "Free" table scenario.
One issue is that there are about a dozen field names in several tables
longer than 10 char that will need to be changed in the structure and code.
After that I will open the DBC and then "remove" each table.
Once that's done I suppose I could just open Windows Explore and delete the
dbc from the folder?
A complete backup will be made prior to any changes being made.
Does anyone who has done this before have any advice?
TIA
Jim
James E Harvey
M.I.S.
Hanover Shoe Farms, Inc.
www.hanoverpa.com
office: 717-637-8931
cell: 717-887-2565
fax: 717-637-6766
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
