Hi Tore,
Nope :(
But I hv an idea how to do it :)
Thks for input.
>Try
>alter table (alias()) add column ...
>or
>alter table (dbf()) add column ...
>
>>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....