Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE delete DBF from disk
Message
From
09/02/2006 11:06:41
 
 
To
09/02/2006 09:20:08
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:
01095064
Views:
14
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....
*****************
Srdjan Djordjevic
Limassol, Cyprus

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

Click here to load this message in the networking platform