Home » Developer & Programmer » Forms » DynamicQuery
DynamicQuery [message #81885] Sat, 29 March 2003 09:57 Go to next message
jan
Messages: 71
Registered: August 2002
Member
i want to search by
having field like Name then afield named operator and then a field name criteria
eg :name :operator (list ofoperators) and then criteria eg 'jan'.
any body willhelpme.
thanx in advance.
Re: DynamicQuery [message #81895 is a reply to message #81885] Sun, 30 March 2003 23:21 Go to previous message
utsav
Messages: 94
Registered: March 2003
Member
Hi,
well u can do this but obviously only one operator will be applicable at one time.

If its from forms use the forms_ddl orexecute_immediate.

In pl/sql just use the execute_immediate.
TRy it, in case of problems do let me know.

utsav
Previous Topic: Tree View
Next Topic: what's wrong with it?
Goto Forum:
  


Current Time: Thu Mar 28 08:46:00 CDT 2024