Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get Memo fields using stored proc on SQL Server???
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
How to get Memo fields using stored proc on SQL Server???
Miscellaneous
Thread ID:
00452721
Message ID:
00452721
Views:
75
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
Map
View

Click here to load this message in the networking platform