Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird problem with SDT
Message
From
30/09/2022 07:57:47
 
 
To
30/09/2022 00:34:37
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01685010
Message ID:
01685012
Views:
50
Thank you Lutz.

>>Hello all,
>>
>>Weird problem with Stonefield Database Toolkit.
>>
>>I added a table to my DBC on my development computer. At one point something broke. I wanted to specify the number of characters for a field. I wanted to specify 30 characters but -31 appeared as the number of characters. At that point I tried to correct this but in the end no way to specify 30 characters so I deleted the table from that DBC.
>>
>>After that I've been able to create that table again.
>>
>>I thought I fixed it but it wasn't.
>>
>>I tried to apply the updated DBC on a test computer. The new tables were copied to the DATA folder but when I look at the available tables in my DBC from within my application the new tables are not there.
>>
>>Not so bad in then end because I installed my latest clean backup.
>>
>>But now I'm wondering how can a problem like this can be solved. I tried validate meta data but it didn't fix it.
>>
>>Regards
>
>Hi Denis
>out of the hip, several. Some need more insight in table structure then others.
>Show in Markdown browser for better readability.
>
>[mark down]
># Copy data
>- create a temporary table (table!) of the structure you need,
> 1. COPY STRUCTURE EXTENDED
> - You might use COPY STRUCTURE EXTENDED
> - modify the data of the help table created with COPY STRUCTURE EXTENDED
> - CREATE FROM to create the temp table
> 2. COPY STRUCTURE
> - create a temporary table,
> - try to alter the structure
> 3. other
> - try other ways to get the table structure
> - AFIELDS
> - DISPLAY STRUCTURE
> - create temp table
>- fill with the data from the old one
>- delete old one
>- pack database
>- recreate old one
>- copy from temp
>- delete temp table
>
># Low level hack
>- hack DBF with an hex editor
>- alter DBC via use
>
># Third party tool I know best
>- get FoxBin2Prg
>- set up to create / recreate DBC and DBF
>- create text representation
>- hack the text files
>- recreate binary representation
>[/mark down]
>
>Lutz
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Reply
Map
View

Click here to load this message in the networking platform