OraFAQ Forum: Forms » Relate From clause block and Database block

Home » Developer & Programmer » Forms » Relate From clause block and Database block

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

Relate From clause block and Database block [message #339355]

Thu, 07 August 2008 06:11

suhasbr
Messages: 23
Registered: April 2008
Location: Chennai

Junior Member

Hi,
I have a Multi item From clause block.I want to relate it to a Multi Item datadase block(from table). I have created an isolated relation between them. I have removed copy value item from the item of the database block.

Now the problem is say i have 20 records in the From clause block and the same 20 records are not getting displayed in the database block. it will display something like first five records that are matching. Next when i scroll down five records in a from clause block i can see next set of records in database block.

Can any one suggest me how to get all data in Database block? Embarassed

Report message to a moderator

Re: Relate From clause block and Database block [message #339671 is a reply to message #339355]

Fri, 08 August 2008 02:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Set 'Query All Records' to 'Yes'.

David

Report message to a moderator

Re: Relate From clause block and Database block [message #339691 is a reply to message #339671]

Fri, 08 August 2008 02:28

suhasbr
Messages: 23
Registered: April 2008
Location: Chennai

Junior Member

Hi,

I am unable to get even if i make it Query all Records.
Please help me Embarassed

Report message to a moderator

Re: Relate From clause block and Database block [message #341197 is a reply to message #339691]

Sun, 17 August 2008 19:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Suhas,

Is this your first form? Are you trying to perhap a standard master-detail relationship? If yes, then I suggest you start again, keep the form simple until the basic process is working and then start making changes. If no, then please explain more fully what you have and what you wish to have in your form.

David

Report message to a moderator

Previous Topic:	how to open a excel file on web by using DDE
Next Topic:	Please provide the way for Database acess and Is socket progrmming possible using Oracle forms (merg

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 00:30:47 CST 2025