>>can i use in the code the foxpro command directly like
>>
>>use tablename
>>
>>browse
>>
>>or do i have to use something else
>
>
>Your question is not clear. Do you mean xBase commands in SQL Server?
>No. SQL Server uses T-SQL.
>
>If you mean accessing data from SQL Server inside VFP, then you have to change your software architecture to 2 or more tiers.
>The data access layer gets to SQL Server data with one of many available options:
>
>- ODBC or OleDB
>- CursorAdapters (using ODBC, OleDB or XML)
>- SQL Passthrough (using ODBC)
>- Remove Views (using ODBC)

I always thought views could be used but now you're telling us to remove them. Hmmm. 8-D

Robert, Alex made a typing error. It should be Remote Views in case you're not familiar with views.

>Check the Client/Server section in the help files for mopre info.
>See the SQLSTRINGCONNECT() and SQLEXEC() functions for examples.