Use of prompted values in sql-cursor code

[Peter Bateman]

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