OraFAQ Forum: Forms » Query Mutlitple Entries

Home » Developer & Programmer » Forms » Query Mutlitple Entries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query Mutlitple Entries [message #290576]

Sun, 30 December 2007 01:06

eshta
Messages: 33
Registered: February 2006
Location: Saudi Arabia

Member

Hi,

I have a tabular form and I want to query for mutliple Entries for the same field, e.g. ID field, I want to query for it the Values in the same time:
1
2
3
4
in this way...How to do it?

Regards

Report message to a moderator

Re: Query Mutlitple Entries [message #290581 is a reply to message #290576]

Sun, 30 December 2007 01:31

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Check this and this.
For Ex. If you are trying to query the details of employees having the empno as 1, 2, 3, 4 or 5 then
1. Enter ":empno" in the empno field after click on Enter-Query button.
2. Click on Execute-Query. It opens querywhere clause text box.
3. Enter empno in (1,2,3,4,5) and click on OK.

By
Vamsi

Report message to a moderator

Re: Query Mutlitple Entries [message #290960 is a reply to message #290581]

Wed, 02 January 2008 05:51

eshta
Messages: 33
Registered: February 2006
Location: Saudi Arabia

Member

Thank you very much it helped alot...

But If I want to apply that in Oracle Application 11i It will throw the following error:
Invalid criteria in field .....

I've reviewd your links and also trid & rather than colon and didn't work with me...

Report message to a moderator

Re: Query Mutlitple Entries [message #290965 is a reply to message #290960]

Wed, 02 January 2008 06:32

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

It is working perfectly for me on Invoice Form in Apps 11i for invoice_num field.

By the way what is your code? And in which form you placed it?

Edit:
I got. You might have set FORMS_RESTRICT_ENTER_QUERY to TRUE.
Check this.
If it is TRUE, you can't use the Query/Where functionality.

By
Vamsi

[Updated on: Thu, 03 January 2008 03:32]

Report message to a moderator

Previous Topic:	How to create items under main menus - Oracle forms
Next Topic:	ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 07:14:27 CST 2025