Re: Report Builder: ORA-00000 Error - Help

Gigio wrote:
>
> > If you call them 'child queries' it means that they have foreign
> > keys
> > to the parent table? Maybe they have just similar columns?
>
> Yes, there'a a foreign key. But the parent and the child queries are
> not single tables, but they are joins!
> If I use query to query data-link, Report fills the parent and child
> column property of the data link automatically, confirming that a db
> constraint exists.
>
> I also tried to create a simple data link: 2 fields in the parent table
> (the parent and the child query with only 1 table, this time!) and 2
> fields in the child query. The result is the same....

[Quoted] [Quoted] So, if there are some similar (the same) columns in both groups, you can use group-to-group data link. In that case all those columns will be used in that data link. What's wrong with this in your case? You want just two columns but there are more?

> but, if I use two
> different tables (not included at all in the previous queries) the
> problem disappears. May be there's a problem with the data in the
> tables?

No, I don't think so...

> The mistery is continuing...
> Bye
> Gigio
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru