Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call Stored Proc Return RS with all records
Message
De
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:
00888343
Vues:
11
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform