>>>
>>>I wanted to send a SQL Select expression to SQL Server and get back a cursor. I know I could do it if I was using ODBC. But I am using ADODB not sure how to do it.
>>
>>If working from FoxPro, why do you think that ADODB is the best option? From FoxPro, besides SPT, you may create database, add connection, create a view or include stored procedure to get the result.
>
>The reason I went from ODBC to ADODB is that I could use CursorAdapter use Varchar(max) type in SQL Server. I don't know if ADODB is the best option but it is recommended when working with CursorAdapter. If I create a stored procedure I still have to call it to get the cursor (on the FoxPro side).
Sorry, I am not aware of Varchar(max) problem. Whether setting FetchMemo in SPT does not help?
CURSORSETPROP("FetchMemo",.t.,0) && set it in advance
?sqlexec(,,,,)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only