Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Oracle Forms and special query operators

Oracle Forms and special query operators

From: Cris Carampa <cris119_at_operamail.com>
Date: Thu, 20 Apr 2006 16:24:23 +0200
Message-ID: <444799c0$0$29096$5fc30a8@news.tiscali.it>


Hello,

I do know that in Oracle Forms it's possible to use special symbols like
">" and "<" in query mode. For example, entering "<3" in a numeric field
means "fetch all the rows where this field is less than 3".

I would like to know if there's a way to ask things like "fetch all the rows where this field is between 3 and 5" or "fetch all the rows where this field is 3 or 5 or 7".

I know that with the "&" symbol you can inject straight SQL into the query, but our users refuse to use it because they have to remember the names of the database columns.

I tried to write things like "between 3 and 5" and "in (3,5,7)" in numeric fields but the Forms engine doesn't seem to like it.

Has someone out there already faced the same problem?

Thank you. Kind regards,

-- 
Cris Carampa (spamto:cris119_at_operamail.com)

potevo chiedere come si chiama il vostro cane
il mio  un po' di tempo che si chiama Libero
Received on Thu Apr 20 2006 - 09:24:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US