Oracle Schema name
Hi,
I just created an report using the DOA component. Everything works fine. Now
I want to use the same report in a different (but semantic equal) oracle
schema.
This fails because in each SQL-Statement I find somethink like this
select * from schemaname.tablename
Is there a way to suppress "schemaname" or to replace it?
RB 11.04; Delphi 2009
Greetings from Germany
Sven
I just created an report using the DOA component. Everything works fine. Now
I want to use the same report in a different (but semantic equal) oracle
schema.
This fails because in each SQL-Statement I find somethink like this
select * from schemaname.tablename
Is there a way to suppress "schemaname" or to replace it?
RB 11.04; Delphi 2009
Greetings from Germany
Sven
This discussion has been closed.
Comments
Take a look at the GetTableNames routine located in the daDOA.pas plugin
file. This is the default way the plugin retrieves the table names for your
database.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com