OraFAQ Forum: Forms » Fetch Query in control bolck

Home » Developer & Programmer » Forms » Fetch Query in control bolck (Forms 10g)

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

Fetch Query in control bolck [message #328648]

Sat, 21 June 2008 02:45

eshta
Messages: 33
Registered: February 2006
Location: Saudi Arabia

Member

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?

Report message to a moderator

Re: Fetch Query in control bolck [message #328743 is a reply to message #328648]

Sun, 22 June 2008 09:55

cjack
Messages: 22
Registered: June 2008

Junior Member

Hi,

You can use a cursor to fetch data, then fetch record into block fields.

Report message to a moderator

Re: Fetch Query in control bolck [message #329101 is a reply to message #328648]

Tue, 24 June 2008 02:07

Frank
Messages: 7901
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?

Report message to a moderator

Previous Topic:	Navigate to another item in enter query mode
Next Topic:	Calling a Excel sheet from Menu Builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 23:07:28 CST 2025