Since it is about Alter Table...
How about VFP9 and
alter table alias() add column ...
to add column to cursor.
It flashes error in VFP9 :( Any workaround ?
>I have experienced problems when I have tried to add more than one field at a time. Try to do it one field at a time.
>
>>>>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....