RE: [sqr-users] SQL output parameter in SQR

[Jeff.Steinfeldt@wellsfargo.com]

Has the filename variable been declared for OUTPUT within the stored
procedure?


Example of SQR code:
@#ProcReturnStatus = N839073.JVproc_DataHubInSyncChk
    @inSync     =       #inSync OUTPUT


Example of procedure declaration:
ALTER  PROCEDURE N839073.JVproc_DataHubInSyncChk @inSync INTEGER OUTPUT


-----Original Message-----
From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
[mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
Behalf Of Charles Burns
Sent: Monday, March 28, 2005 11:24 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQL output parameter in SQR


Here's my sqr version:
 
SQR Server/6.1.3/PC/Windows NT 4.0/Odbc Level 2/Oct 20 2000.
 
Database is MS SQL Server 2000
 
I'm trying to print the output parameter from a Stored Procedure. Here's the
code I'm using, I can print everything but the $filename variable. Thanks in
advance for any help you can give. 
 
begin-setup
declare-variable
 text $filename
end-declare
end-setup
begin-program
 do main
end-program
begin-procedure main
    input $where
    input $bdate maxlen=10 type=char 'Enter Beginning Date.'
    input $edate maxlen=10 type=char 'Enter Ending Date.'
    
execute  maxlawbill @bdate =  $bdate,@edate =  $edate,@filename = $filename
output show $filename print $bdate (+2,1)BOLD print $edate (+2,1)BOLD print
$filename (+2,1)BOLD Print 'SUCCESS!!'(+2,1)BOLD print 'End of Procedure'
(+2,1) end-procedure

                
---------------------------------
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site! 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users