You could for example write something like this inside your VFP code to access the SQL db:
local lnSql as integer
lnSql = SqlStringConnect("SERVER=(local); UID=sa; PWD=sa; DATABASE=testdb;")
SqlExecute(lnSql, "SELECT * FROM testtable", "vfpcursor")
SqlDisconnect(lnSql)
select vfpcursor
browse normal
HTH
>Thanx for the update, Can U let me know where to write this syntax?
>
>Saif
robert.oh.