Information générale
Titre:
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?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement