Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call Stored Proc Return RS with all records
Message
 
 
À
21/03/2004 18:45:44
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00888256
Message ID:
00888347
Vues:
13
Can you explain what the problem is? I don't see any connection between UI and and ADO RecordSet in your code.

>Sergey,
>
>Sorry, this is from my other 'Test', my problem now is, i can get the RS but i can´t pass it to the UI.
>
>I call it like this in my Form
>
>Load::Method
>
>.oRS0     = createobject('ADODB.RecordSet')
>SET ClassLib TO Clientes, Layers
>.oCliente     = CreateObject('Ficha_Clientes', 'DataClass')
>
>Button::Click
>
>llOK=.oCliente.lst_vendas_cliente(.oRS0, lcParam, "usr_sp_Clientes")
>
>Ficha_Clientes::lst_vendas_cliente
>
>lparameters toRS, tcPar, tcStoredProc
>LOCAL lOK
>llOK = .oData.GetStoredProcRecordSet(toRS, tcPar, tcStoredProc)
>
>oData.GetStoredProcRecordSet::Method
>Lparameters toRS, tcParam, tcStoredProc
>   .SetCommandProperties(tcStoredProc)
>   WITH .oCommand
>	.Parameters("@Param1").Value=tcParam
>	toRs=.Execute
>   ENDWITH
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform