Home » Developer & Programmer » Forms » Fetch Query in control bolck (Forms 10g)
Fetch Query in control bolck [message #328648] Sat, 21 June 2008 02:45 Go to next message
Messages: 33
Registered: February 2006
Location: Saudi Arabia

Hi to all,

I want to fetch a query result (multiple records) in a control block, the problem I am facing it throws an error if the query retruns more than one record!!!

How it can be done?
Re: Fetch Query in control bolck [message #328743 is a reply to message #328648] Sun, 22 June 2008 09:55 Go to previous messageGo to next message
Messages: 22
Registered: June 2008
Junior Member

You can use a cursor to fetch data, then fetch record into block fields.
Re: Fetch Query in control bolck [message #329101 is a reply to message #328648] Tue, 24 June 2008 02:07 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
If the query returns more than one record, they are either duplicates, allowing you to use distinct, or you have to add a where-clause.
If you cannot tell which record to use from the set of returned rows, how can Forms?
Previous Topic: Navigate to another item in enter query mode
Next Topic: Calling a Excel sheet from Menu Builder
Goto Forum:

Current Time: Fri Jul 28 08:06:10 CDT 2017

Total time taken to generate the page: 0.25010 seconds