>>>>Hi,
>>>>I have one problem
>>>>After ALTER TABLE .. ADD COLUMN ..etc. (FREE table)
>>>>On my disk exist files
>>>>mytable.BAK
>>>>mytable.TBK
>>>>mytable.FPT
>>>>
>>>>and no myTable.DBF
>>>>
>>>>Why it might be losted? Any help! Thanks
>>>>Denis
>>>
>>>Not enough disk space? By the way, your old data is still present, you just must rename the BAK and FPT-files.
>>
>>Hi Tore
>>Disk space ok (30Gb free)
>>This is application error.. customer reports program splash "Select DBF" vfp window. I had check.. program prepares template cursor to upload on web... here 4 ALTER TABLE command... and after EACH command.. DBF losted..
>>When first "Select dbf" window appears. I rename BAK to DBF, TBK to FPT.. then push "Ok" - and .. next line.. again window "Select DBF" and no DBF file on disk
>
>I have never had any problems with this. Are you sure that nobody else is also using the table?


Hi again
We just run same application on another PC.. same problem
now.. we open data in MINI VFP (emulation of command window)
First ALTER TABLE demage DBF

Line looks like here:

Alter Table iartikel Add Column user_c1 c(100) Add Column user_c2 c(100) Add Column user_c3 c(100) Add Column user_c4 c(100) Add Column user_c5 c(100)

after this line.. no DBF more....
Columns count of table before ALTER is 35

Thats realy strange for me....