Re: ODBC and Oracle

From: Mike Layng <mlayng_at_micromine.com.au>
Date: Thu, 9 Mar 2000 10:01:29 +0800
Message-ID: <38c70662@pink.one.net.au>

Thanks for your reply Thorsten,

I am working with an old app that we actually had running on a Paradox Dos database. The application creates a lot of SQL statements dynamically and at this stage it is not feasible for us to force these statements to use <owner>.<tablename>. I was sort of hoping that there was some way of avoiding this.

Thanks,
Mike.

Thorsten Bertram <thorsten.bertram_at_planware.com> wrote in message news:8a58tt$1tad$1_at_wrath.news.nacamar.de...
> Hi Mike,
>
> set the owner of the table in front of the table name, which means
> "Select * from <owner>.<tablename>".
>
> I think that will solve your problem.
>
> regards
> Thorsten
>
Received on Wed Mar 08 2000 - 20:01:29 CST