Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get Memo fields using stored proc on SQL Server???
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
How to get Memo fields using stored proc on SQL Server???
Divers
Thread ID:
00452721
Message ID:
00452721
Vues:
76
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
Fil
Voir

Click here to load this message in the networking platform