Re: Datablock query problem (where)
From: Frank <frankbo_at_interaccess.nl>
Date: Tue, 24 Oct 2000 16:25:08 +0200
Message-ID: <8t464d$op2$1_at_porthos.nl.uu.net>
Date: Tue, 24 Oct 2000 16:25:08 +0200
Message-ID: <8t464d$op2$1_at_porthos.nl.uu.net>
I suspect this rowid is the cause...
If that is inserted for both tables, there is no distinction
between table_a.rowid, and table_b.rowid.
What are you exactly trying to accomplish? This is forms isn't it?
Some details would help, you know!
-- Frank Scott <swesley_at_student.ecu.edu.au> schreef in berichtnieuws 39F25380.B50D3CE2_at_student.ecu.edu.au...Received on Tue Oct 24 2000 - 16:25:08 CEST
> G'day
>
> I've been desperately trying to figure out how to add a where clause to
> a database block that references another table.
> Even if I add the other table to the data source names, and qualify each
> field referenced with the table name, at runtime I receive this error:
> ORA-00918 column ambiguously defined
> If I run the same query in pl/sql, it works after I take out ROWID
> (which is inserted by tools automatically) in the select statement.
>
> This only happens when I try to reference a column from another table. I
> only have the one block in my form, and I've tried adding the other
> table as another db block, but to no avail.
>
> Can anyone help?
>