Re[2]: Stored procedure INOUT parm

[eric.delong@xxxxxxxxxxxxxxxxx]

     MS Visual C++. Actually, I think I may have found the documentation 
     I needed. It seems we need to use SQLPrepare and SQLBindParameter 
     for both parm1 and parm2. My associate was trying to pass parm1 as 
     a character literal and bindParm for the second. 
     
     As usual, I got my part ready to test in about five minutes. He 
     says he'll be ready to try his part Monday (probably). :)
     
     I sure am glad these PC programmers have all these productivity 
     tools to make their coding easier. Otherwise, I'd have to wait til 
     next month to test......
     
     BTW, if I'm still chasing the wrong rabbit, please let me know. 
     
     thanks again...
     eric.delong@pmsi-services.com


______________________________ Reply Separator _________________________________
Subject: Re: Stored procedure INOUT parm 
Author:  <MIDRANGE-L@midrange.com> at INET_WACO
Date:    5/19/00 8:38 AM


What language are you using? With Delphi just set the parameter to In/Out 
and then after the call do something like
     
SomeVariable := StoredProc1.ParamByName('SomeParm').Value;
     
VB with ADO requires a little more setup but in the end you reference the 
Parameter's value the same way.
     
HTH
Eric Wilson
______________________________________________ 
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407
     
     
----- Original Message -----
From: <eric.delong@pmsi-services.com> 
To: <midrange-l@midrange.com>
Sent: Friday, May 19, 2000 8:34 AM
Subject: Stored procedure INOUT parm
     
     
>
>      I've written a stored procedure in RPG4, and tried to pass back a 
>      return value as the second parm. We want a PC app to call this
>      procedure via ODBC, but we can't figure out how to map the INOUT
>      parm to a host variable in the PC app. Can someone point me in the 
>      right direction?
>
>      tia,
>
>      eric.delong@pmsi-services.com 
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com. 
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. 
> | To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
david@midrange.com
> +---
     
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com. 
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. 
| Questions should be directed to the list owner/operator: david@midrange.com 
+---
     


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---