[sqr-users] SQL output parameter in SQR

[Charles Burns <charlesburns70@yahoo.com>]

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