Re: Informix ISQL and report ranges (user input)
In article <kcjDB9rrG.AEy@netcom.com> kcj@netcom.com (Kate Juliff) writes:
>
>I've JUST purchased ISQL and everything looks straight forward enough.
>However it's not clear to me how one goes about getting it set up so that the
>end user can specify begin and end ranges for a report.
>
>For example, suppose I set up a report for line items using
>a table of all line items. But I want the user to be able to put in
>begin and end dates so that only a subset of rows are reported. What
>should I
>do. I can't easily see how to do this from the manual. But surely the
>facility is there...
>
>Thanks,
>
>Kate
{sample of date range for reports in isql [sacego/saceprep]}
define
variable bdate date
variable edate date
end
input
prompt for bdate using
"Enter beginning date > "
prompt for edate using
"Enter ending date > "
end
select *
from table_name
where date_field between $bdate and $edate
end
format
...
end
Hope it helps!
Bob Beaulieu
bobb@netcom.com
--
___________________________________________________________________
| _____ _____ ______ _____ _____ ___ ___ _____ __ |
|| ___| |_ / |_ _|| _ \\ / _ \\ \\ \\/ / | ___| | | |
|| ___| / /_ | | | / | _ | \\ / | ___| | |__ |
||_____| /_____| |__| |__|__\\ \\_/ \\_/ \\__/ |_____| |_____| |
|$Best Fares$...........Great Service........International/Domestic |
|Tel(408)978-0808 Fax:(408)978-7024 Internet: eztravel@netcom.com |
-------------------------------------------------------------------