>can i use in the code the foxpro command directly like
>use tablename
>browse
>or do i have to use something else
>thanks you
* open connection to SQL Server
lnFileHandle = SQLConnect("dsn name of your database")
* pull back data from a table into a VFP cursor
= SQLEXEC(lnFileHandle, "SELECT name FROM staff","cResult")
* browse data
select cResult
BROWSE
* discconect from SQL SERVER
SQLDISCONNECT(lnFileHandle)
Here is a link for how to translate your VFP SQL commands into T-SQL (SQL Server's type of SQL)
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP