Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date parameters form
Message
De
10/04/2002 16:05:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
10/04/2002 15:45:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00643430
Message ID:
00643453
Vues:
9
>
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform