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