Use of prompted values in sql-cursor code

[Reinke, Chuck]

This is useful approach, and it would work if you weren't dealing with
dates. Again, it's how dates are kept in Subfiles. Just try your solution
and see what happens.

Chuck

-----Original Message-----
From: Peter Bateman [mailto:shediac92@hotmail.com]
Sent: Tuesday, October 15, 2002 11:39 AM
To: powerh-l@lists.swau.edu
Cc: chuck.reinke@cognos.com
Subject: Use of prompted values in sql-cursor code


Chuck:
You should be able to use host variables if their values
are known when the cursor is opened.

Please give the following a go:-

Declare XYZ cursor for select A, B, C, D  from XTABLE &
                    where D between :XBEGIN and :XEND
; pass one get the values
Define XBEGIN date parm prompt "Enter start date:"
Define XEND date parm prompt "Enter end date:"
Report summary XBEGIN XEND
Set subfile name XDRIVER
Go
Access *DRIVER link to XYZ
Report A B C D
Go

Regards,
Peter Bateman





_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.