Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE delete DBF from disk
Message
From
09/02/2006 08:48:31
 
 
To
09/02/2006 07:08:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01094908
Message ID:
01094969
Views:
10
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....
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform