Re: Informix ISQL and report ranges (user input)
Kate,
check into the PROMPT command, its part of the input section of ACE reports.
the systax is something like:
define
variable start_date date
variable end_date date
end
input
prompt for start_date using "Enter Start Date : "
prompt for end_date using "Enter End Date : "
end
select *
from tables
where sdate >= $start_date
and edate <= $end_date
end
i believe you can find this in the SQL User Guide.
>
> 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
>
>
--
regards,
+----------------------------------------------------------------------------+
| . . | Bob Baskett |
| ... ... | Software Engineer |
| ..... ..... | Business Systems Integration Group |
| .. ... .. | Semiconductor Products Sector |
| . . . | Mesa, AZ |
| | President, Informix Users Group Of Arizona |
| Motorola, Inc. | rzbj40@email.sps.mot.com |
+----------------------------------------------------------------------------+