I was wondering.. when I sent an SQL query to oracle via OLE DB it contained
a function written in oracle. VB sent a run time error saying that function
is an unrecognized column name. the same happened in delphi (same ora error
even). the solution was to place the owner name infront of the call to the
function (select [owner].[functionname)...), but i didn't need to do that in
SQL navigator, the query worked without the use of owner scope.
what's really interesting is that I've had similar problem not just with VB
but with magic and it's connection with SQL server 7. simple query failed
when SQL server declared that the tables as unknown to it. it was solved by
prefixing the owner name to the tables. magic does not use OLE db(VB) or
ODBC(Delphi) but it's own gateway.
what's the commonality here?