Home » Developer & Programmer » Reports & Discoverer » datalink not functioning
datalink not functioning [message #241962] Thu, 31 May 2007 04:03 Go to next message
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I have a primary SQL query where I fetch sequence1 number. Then I have the second SQL query for details so I also have sequence2 number. I create datalink between this two so I have that relationship sequence1 -> sequence2. The problem is when I get sequence1 = 1 in my primary query, it fetch sequence2 = 2 on second query. When I get 2 it gets 2 on second. While if I add the line "and sequence = :sequence1" on my second query, it returns correct data. Can anybody help me to fix this datalink?

This is on oracle report, (reportbuilder and i'm running on oracle forms ver.5
Re: datalink not functioning [message #242131 is a reply to message #241962] Thu, 31 May 2007 14:13 Go to previous message
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Could you please post your query, some sample data (table definitions and contents and output) and the version of the database you're working with?
Previous Topic: destype=mail
Next Topic: Oracle Discoverer 3.1 errorr - ORA-03123
Goto Forum:

Current Time: Fri Oct 21 08:13:26 CDT 2016

Total time taken to generate the page: 0.09724 seconds