Re: Search by < or > with date in FORMS

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/04/18
Message-ID: <5j894r$m2r@info.csufresno.edu>#1/1

In article <1997Apr18.035649.21485_at_van.oz.au>, Tim Nguyen <tim_at_van.oz.au> wrote:
>Hi world,
>I have a basetable form which base on a table that stores
>customer's information. I would like to search for a number of
>customers which have birthday greater than or less than a certain
>date. I can search by exact date but cannot put in a condition
>like above for query on form. In sql I could do something like
>"select * from customers where birthday > <some-date> and
>< <some-other-date>"
>
>Thanks in advance,
>Tim

You can search on a range of dates in a base-table form that is using Oracle's default processing using either of two methods. Both methods are used from enter-query mode.

1. Use the # character in any column followed by a select condition. It helps to think of the # character as the phrase, "where Column_Name...". Example: #between '01-JAN-97' and '31-JAN-97'

    If you press Ctrl-e (lower-case e only), an edit window pops up     and you can enter the full string easily. (But only if the Query     Length property on the item is large enough to hold your string.)

2. Place a colon (:) in any column and then Execute-Query. A

    Query/Where window will pop up. On this window you may enter one     or more conditions to select rows from the table exactly as you     would in a SQL Where clause. (Do not include the word "where".)

In either of the above methods, you can include a date format if you want to specify your date in something other than the default format. Example: birthdate between to_date('01011997','mmddyyyy') and...

Both of the above methods are documented for my QA form, (which behaves as a default or base-table form) in the QA User Guide on my web site.

HTH
Steve Cosner
http://members.aol.com/stevec5088 Received on Fri Apr 18 1997 - 00:00:00 CDT