parames
14th September 2002, 07:27
Hi list,
I've create a new query in maintain query data session.
select ......
from .......
where ..... and
tdinv100.idat >= tdinv100.idat.f and
tdinv100.idat <= tdinv100.idat.t and
....

After this, i do maintain the report script to do some processing. Now, my problem is how do i get the USER INPUT value of tdinv100.idat.f and tdinv100.idat.t inside my report script..

I need this because i want to do another sql query inside my report script to get data from other table using this date range...

I don't want to use session and create a program script....

Please advice me..

Thanks a lot,
Best Regards,
Parameswari Sellaparma

hklett
14th September 2002, 19:18
I am not sure that this do work with easy sql but try
to define the fields you want to use in the report script as an input field of the report and
check if you get the right values.

Normaly this method is used to transfer variables from the program script ( in wich they must be declared as extern ) to
a report ( or form ).

Good Luck

Holger