>>>Hi all!
>>>
>>>was wondering if anyone can tell me what might have happened to truncate some field names in one of my tables. I believe these names were >10 chars and worked fine for awhile, but somehow they got truncated back to 10 chars, which of course messed up a few reports, etc. I do remember 'modifying' the table once or twice, but would this cause it? Or maybe it was deleteing and then re-adding the table....
>>>
>>>TIA,
>>>Dan
>>Dan,
>>Might it be you freed the table and then readd back to DBC.
>>Cetin
>
>I do believe i did delete it from the Program Manager ( not frm the disk) and re-add it back to the program manager because somehow I had placed it in the wrong sub-dir.
>IS there a way to prevent this from happening in the future or a way to accomplish this without losing the long field names?
>Thanks
>Dan
There are ways :) Main problem "which one is easy?". Some require directly playing with DBC, DCT and lowlevel. Some require lowlevel playing with table. one is using gendbc(x).
- Whenever you have your DBC changed, run home()+"tools\gendbc\gendbc" (or gendbcx from
www.stevearnott.com) to have a prg representation of DBC and tables (stored procs in .krt).
- Have a new directory tree as you would want to have.
ie: If you want :
...\App\Data
...\App\Data\TableGroup1
...\App\Data\TableGroup2
Create an empty new dir and subdirs whereever you like ie: ...\App to \temp\newapp :
\temp\newapp\Data
\temp\newapp\Data\TableGroup1
\temp\newapp\Data\TableGroup2
- Modify prg to create dbc and tables in dirs that you want them to be and run.
- Write a small prg that would loop one dbc's tables and append them to new empty ones.
- Remove ..\app\data. Copy ..\newapp\data to ..\app
Well, another and easiest :
close all
Set excl on
use newfullpath\tablename
Cetin