d2k-enter-query [message #78983] |
Wed, 10 April 2002 21:26 |
Amita Kapadia
Messages: 8 Registered: January 2002
|
Junior Member |
|
|
Dear All,
In Enter-query mode, I want to query on fields :
1. empno
2. date range (from date and to-date)
after all three fields are entered then execute query.
can you tell me how to proceed.
Thanks
Amita
|
|
|
Re: d2k-enter-query [message #78986 is a reply to message #78983] |
Thu, 11 April 2002 00:09 |
nik
Messages: 55 Registered: January 2002
|
Member |
|
|
amita,
1. from what you have said my understanding is that you have done all there is to be done, and there is no need to proceed, after all fields have been entered, press execute_query.
2. But if you want to know HOW to query on fields then you need to set the default where on the block property. SO for example,
Lets say you'r block is based on EMPLOYEE table;
WHERE emp_no = :block1.empno and
emp_date between :block1.datefrom and :block1_dateto
you'll see this is block property sheet.
I think this is what u mean, I'm not sure, maybe you could clarify.
|
|
|