Hi john,

Thanks for your reply,
So, i can use SQLEXEC() without bothering anything.

i have one more qustion Regarding Dbf files and Vfp 8.00,
i have a table and table extension i put as '.Dbt'

Say, eg. Instead 'Abc.dbf' i using as 'Abc.Dbt'.
i m doing all transctions using Sql Statement(Instead of Append Blank and Replace),
But, Now i found in the directory each table has created its own CDX files and some tables
which i m using freqently get currupted.

So, this is because of '.Dbt' table extensions or Vfp 8.0 SQL compatibility problems.

Or What setting i have to do for smooth excecution of SQL Statements.

With thanks and Regards
Abdulla