OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Query

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

Query [message #205240]

Fri, 24 November 2006 00:53

orafan2003
Messages: 122
Registered: February 2006

Senior Member

Hi,
There is a query like this.
These are some order details. Every person will have a unique order id,telephone and customer id.

select * from orders where order_id=11 and telephone=2323234 and customer_id=123451;

I am using omniportlet and simple parameter form...Simple parameter form to pass the parameters and omniportlet to display the data.
I want my query to work like this.
In my simple parameter form, I can select all the 3 parameters and get the result ie 1 row for that particular sale. Or I will just enter any one of the parameter values and get the result.
How should I frame my query.

Report message to a moderator

Re: Query [message #205391 is a reply to message #205240]

Fri, 24 November 2006 07:43

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi,

if you can tell me what is 'omniportlet' then i might help you ...

Bye
Ashu

Report message to a moderator

Re: Query [message #205624 is a reply to message #205240]

Sun, 26 November 2006 21:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do you have an 'omniportlet' manual? Are there any examples in it? Does Forms know about the directory in which you have placed the 'omniportlet' code?

David

Report message to a moderator

Previous Topic:	PLSQL-Webservice
Next Topic:	calling forms using parameters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 21:58:52 CDT 2025