Home » Developer & Programmer » Forms » Query
Query [message #205240] Fri, 24 November 2006 00:53 Go to next message
Messages: 122
Registered: February 2006
Senior Member
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.

Re: Query [message #205391 is a reply to message #205240] Fri, 24 November 2006 07:43 Go to previous messageGo to next message
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member

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

Re: Query [message #205624 is a reply to message #205240] Sun, 26 November 2006 21:18 Go to previous message
Messages: 10180
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?

Previous Topic: PLSQL-Webservice
Next Topic: How to create Hyper Link with Forms?
Goto Forum:

Current Time: Mon Aug 21 22:42:31 CDT 2017

Total time taken to generate the page: 0.04695 seconds