Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date parameters form
Message
From
10/04/2002 16:05:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
10/04/2002 15:45:45
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00643430
Message ID:
00643453
Views:
8
>
>I have a form, which I use as a navigator, containing all the tables/views I need. On this form I have a button which calls a form used to collect the dates which I need to run reports on. I have this code in the click event of the button on the navigator form which collects the dates and sends them back to a wait window.
>
>DO FORM TestParam
>
>WAIT WINDOW "BEG: " + DTOC(gaDateRange[1]) + " End:" + DTOC(gaDateRange[2]);
>+ ' Employee: ' + gaDateRange[3]
>
>RELEASE gaDateRange
>
>How can I modify this code so that I can select only appointments for these dates and send them to a report. I guess in other words, I want these parameters sent to the report, but am unsure of how to define / call them. Another way of putting it is I need to take the dates from the wait window and pass them to a report.

Usually I use a SELECT - SQL statements (or several) to prepare the report.

In this case, you would need something like this:
select * from MyTable;
  where DateField between gaDateRange(1) and gaDateRange(2);
  into cursor TempResult
* Now, run the report
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform