Home » Developer & Programmer » Forms » d2k-enter-query
d2k-enter-query [message #78983] Wed, 10 April 2002 21:26 Go to next message
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 Go to previous message
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.
Previous Topic: how to highlight deleted records
Next Topic: Re: migration tool for oracle forms 4.5 to forms 6i
Goto Forum:
  


Current Time: Thu Aug 06 09:08:43 CDT 2020