>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