>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