Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Return variable question
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00667483
Message ID:
00667548
Vues:
17
>>>>I have a stored proc that accepts three parameters - then does a whole lot of processing before doing the final select statement - which I'd like to return as a recordset to VB.
>>>>
>>>>However, the recordset is not being created in VB - I think I may have to declare the select statement as the return 'value' or something ... I've called simple SP's before that only had "select * from whatever" and the recordset was returned without a problem.
>>>>
>>>Maybe your SP returns more than one recordset? Try to run it in QA and see what it returns.
>>
>>The SP only 'returns' one recordset in QA - however, within the SP there are a number of select from ... into table variables. Also, for testing purposes I have a few 'Print @Variable' statements - which do show up in the messages tab in QA - but there is only the one set of records showing up in the grid view.
>
>Do you have SET NOCOUNT ON at the beginning of your SP? How do you call that SP from VB?

Sergey, SET NOCOUNT ON was the answer - thanks again for your assistance.
Al Williams

Anola MB, CANADA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform