Remove is the right term :-) use CAs instead :o)
>>
>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.