Print Thread
How can I retrieve the value of variables in a store procedure?
#653 07/03/00 02:35 PM
Joined: Jul 2000
Posts: 1
garbagnate milanese
L
luca Offline OP
Member
OP Offline
Member
L
Joined: Jul 2000
Posts: 1
garbagnate milanese
How can I retrieve the value of variables in a store procedure?

This one retrive only the first variable (StoreProcedure.GetParameter(0))

StoreProcedure.CallProcedure ('SP_EMAIL_INS',[
parString,
AddressId,
Address,
mailDirection,
EmailItem.MailBody,
EmailItem.MailSubject,
EmailItem.MailImportance,
EmailItem.MailSent,
parString,
ToAddressList,
CcAddressList,
DossierIdList
]);

sessionMain.Commit ;

EmailItem.MailID := StoreProcedure.GetParameter(0);

EmailItem.JournalCode := StoreProcedure.GetParameter(1);


____________
Luca
Re: How can I retrieve the value of variables in a store procedure?
#654 07/03/00 06:31 PM
Joined: Jul 2000
Posts: 1
MILANO, ITALIA
C
Member
Offline
Member
C
Joined: Jul 2000
Posts: 1
MILANO, ITALIA
Luca,
check parameters position.

[quote]Originally posted by luca:
How can I retrieve the value of variables in a store procedure?

This one retrive only the first variable (StoreProcedure.GetParameter(0))

StoreProcedure.CallProcedure ('SP_EMAIL_INS',[
parString,
AddressId,
Address,
mailDirection,
EmailItem.MailBody,
EmailItem.MailSubject,
EmailItem.MailImportance,
EmailItem.MailSent,
parString,
ToAddressList,
CcAddressList,
DossierIdList
]);

sessionMain.Commit ;

EmailItem.MailID := StoreProcedure.GetParameter(0);

EmailItem.JournalCode := StoreProcedure.GetParameter(1);
[/quote]

Re: How can I retrieve the value of variables in a store procedure?
#655 07/07/00 06:05 PM
Joined: Jun 2000
Posts: 13
B
Member
Offline
Member
B
Joined: Jun 2000
Posts: 13
I think the second GetParameter should be (9) instead of (1).
EmailItem.MailID := StoreProcedure.GetParameter(0);
EmailItem.JournalCode := StoreProcedure.GetParameter(9);


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 13 (0.005s) Memory: 2.5049 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-20 12:31:20 UTC
Valid HTML 5 and Valid CSS