General information
Title:
How to get Memo fields using stored proc on SQL Server???
I could really use some help with this!!
I'm invoking a stored procedule on SQL Server 6.5. It works, as shown below, by having 3 parameters sent to it:
SQLPrepare(hConn, '{CALL GetReport(?X, ?Y, ?Z)}')
SQLExec(hConn)
In return, it gives me a 1-row cursor with about 10 columns. Everything fine, EXCEPT that there are two columns in the cursor that are memo format in SQL Server, and these come back as blank in the cursor. I'm stumped. How to I set up the SQL command to return the memo stuff as well as the fixed-column stuff?
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