Re: Querying Forms5
From: ACJohnst0n <acjohnst0n_at_aol.com>
Date: 09 Oct 2000 20:55:34 GMT
Message-ID: <20001009165534.25182.00001129_at_ng-da1.aol.com>
Date: 09 Oct 2000 20:55:34 GMT
Message-ID: <20001009165534.25182.00001129_at_ng-da1.aol.com>
Try this....
Run the form, press 'enter_query'.
In one of the columns, enter ":q" ( or any string beginning with a colon ) then
press 'execute_query'.
You'll get a 'query/where' box into which you can enter any SQL*Plus Where
clause, so you could enter, for example "date_field_1 is null". Then press OK
to complete the query.
To query between two dates, do the same and enter the Where clause something like "date_field_1 between to_date('20000101','YYYYMMDD') and to_date('20001231','YYYYMMDD') "
Hope that works for you. Happy coding!
Cheers
AJ
Received on Mon Oct 09 2000 - 22:55:34 CEST