Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call Stored Proc Return RS with all records
Message
From
21/03/2004 18:45:44
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00888256
Message ID:
00888343
Views:
9
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
João Batista

>In this case what following code is for?
> toRS.ActiveConnection = .oConnection
> toRS.Source=tcTabela
> .SetRecordSetProperties(toRS)
> toRS.Open
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform