Home » Developer & Programmer » Forms » Relate From clause block and Database block
icon5.gif  Relate From clause block and Database block [message #339355] Thu, 07 August 2008 06:11 Go to next message
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
Re: Relate From clause block and Database block [message #339671 is a reply to message #339355] Fri, 08 August 2008 02:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Set 'Query All Records' to 'Yes'.

David
Re: Relate From clause block and Database block [message #339691 is a reply to message #339671] Fri, 08 August 2008 02:28 Go to previous messageGo to next message
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
Re: Relate From clause block and Database block [message #341197 is a reply to message #339691] Sun, 17 August 2008 19:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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:
  


Current Time: Wed Dec 07 22:07:51 CST 2016

Total time taken to generate the page: 0.11031 seconds