| datalink not functioning [message #241962] |
Thu, 31 May 2007 04:03  |
|
|
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 3.0.5.8.0) 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  |
skooman
Messages: 913
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
