Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Sql Statement and Table Curruption Msgs.
Versions des environnements
Network:
Windows 2000 Server
Dear Experts,
I developed a small application in vfp8, in that i using all the commands in
Sql Format (For Eg. Instead of Append blank i m using Insert into Statement, and in the palce of 'Seek' i m using 'Select' statement with Cond. Etc., I m not using Data Environment, open the table on demand basis).
now i m most of the time facing Table Curruption probs.
whe i trying open gives the error that 'Not A Table'.
then i add 'Set Table Validate to 0', after that working fine
for some time Now it satarted again. this time i set table
validate from 0 - 3, but no result.This happends only for
the table which is using in multi users.
(Egs. Invoice table,purchase table and item masters table etc...)
Now i m really confused that will Vfp really support Sql
satament or shall i go back to Vfp traditional command
like 'Append Blank' and 'Replace' statatement.
In addtion to this for secuirty pupose i m using
'.DBT' instead of '.DBF' Table Extensions.
Eg. My insert statment is like this
Insert Into c:\Dev\Data\ABC.DBT(Fild1,Fild2,Fild3) Values (X,Y,Z ).
Pls help me where i m missing.
Thanks in advance
Regards
Abdulla
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement