Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALTER TABLE delete DBF from disk
Message
De
09/02/2006 11:06:41
 
 
À
09/02/2006 09:20:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01094908
Message ID:
01095064
Vues:
12
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform