Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call Stored Proc Return RS with all records
Message
 
 
To
21/03/2004 18:45:44
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00888256
Message ID:
00888347
Views:
12
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform