Re: Datablock query problem (where)
Date: Mon, 23 Oct 2000 13:22:17 -0600
Message-ID: <jj0J5.74$qJ2.22749_at_wdc-read-01.qwest.net>
It is very unclear what you mean by "block that references another table" and "reference a column from another table".
Does your database block reference ONE table, or a view that joins multiple tables, or what?
Maybe an example of your pl/sql would help. Also, what kind of tools insert rowid? Perhaps you need to tell us what you are working with?
"Scott" <swesley_at_student.ecu.edu.au> wrote in message
news:39F25380.B50D3CE2_at_student.ecu.edu.au...
> 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?
>
Received on Mon Oct 23 2000 - 21:22:17 CEST