OraFAQ Forum: Forms » Issue in Fin Query screen

Home » Developer & Programmer » Forms » Issue in Fin Query screen

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

Issue in Fin Query screen [message #610574]

Fri, 21 March 2014 08:14

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Hi ,

I am having a Find Screen which contain five column.
If a user enters any of the field then according to that another window will open and the result will be shown.

I used ONETIME_WHERE for this criteria.Please let me know if you have any other approach to achieve it.

Thanks

Report message to a moderator

Re: Issue in Fin Query screen [message #610580 is a reply to message #610574]

Fri, 21 March 2014 08:58

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What's wrong with built-in querying mechanism? You need only one data block, enter query mode, enter search criteria, execute query and the result is here - no additional coding is necessary.

Report message to a moderator

Re: Issue in Fin Query screen [message #610582 is a reply to message #610580]

Fri, 21 March 2014 09:05

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

I want to know if user is going to put any combination of value whether it will work.??
And from starting i was using ONETIME_WHERE clause so i am not aware of built-in mechanism.

Report message to a moderator

Re: Issue in Fin Query screen [message #610632 is a reply to message #610582]

Sat, 22 March 2014 04:55

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Of course that ANY combination won't work - that would be one that doesn't return any records to the screen.

ONETIME_WHERE is "advanced", default behavior is "basic". How come you didn't learn basics first?

Report message to a moderator

Re: Issue in Fin Query screen [message #610733 is a reply to message #610632]

Sun, 23 March 2014 14:39

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Hi Littlefoot,

I am aware of the basic in oracle forms, and the default didn't worked for me, because user is going to put any combination so i opted for ONETIME_WHERE.
Please let me know if you have any further approach to achieve it.

Thanks

Report message to a moderator

Re: Issue in Fin Query screen [message #610736 is a reply to message #610733]

Sun, 23 March 2014 16:22

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sorry, but - in my opinion - you are wrong. Forms is perfectly capable of handling "any combination" without you programming it.

Report message to a moderator

Previous Topic:	[REQ] Oracle Developer 6.0 for Win 8.1 x32 x64 ?
Next Topic:	Sum option in Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:43:56 CDT 2024