Re: Oracle schema

From: David Lewis (davidl_at_ocuco.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 17:35:52 +0100

How many queries are we talking about here ? If this is a job you only have
to do once because you are converting databases, then you can significantly
cut down the time it takes by editing the DFM text directly and do a search
and replace - everywhere you have "FROM " you substitute "FROM MYSCHEMA.".
That would catch many instances, then just do a search for "SQL.Strings ="
and manually check and modify the ones that couldn't be caught by the
substitution. You will also have to put the schema name into the TTable
TableName and IndexName properties.

"Francois Piette" <francois.piette@overbyte.be> wrote in message
news:40b1b76d@newsgroups.borland.com...
> Is there a way to specify a default schema when querying an Oracle
database
> with a ADO component ?
>
> I have an application to convert to Oracle database. In the original
> application, all SQL queries doesn't qualify table names. To convert to
the
> Oracle database, I have to edit all queries to qualify all table names
with
> schema.
> Example:
> Original: SELECT * FROM MYTABLE
> Conversion: SELECT * FROM MYSCHEMA.MYTABLE
>
> This is a lot of work given the large number of queries. I would spare a
lot
> of time only if I could specify "MYSCHEMA" as default value !
>
> If it makes a difference, the application is using Delphi 7.01,
> TAdoConnection, TAdoQuery, Oracle 9 client and Oracle 8 database.
>
> Any advice appreciated.
>
> --
> francois.piette@overbyte.be
> Author of ICS (Internet Component Suite, freeware)
> Author of MidWare (Multi-tier framework, freeware)
> http://www.overbyte.be
>
>

Relevant Pages

  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: PyTable?
    ... A database plan ... Normally the schema is created in Python code, ... queries, for instance. ... As to BasicProperty, its purpose is to allow for defining rich ...
    (comp.lang.python)
  • Re: Question on conversion to ADP
    ... the money toward developping .NET technologies instead of Access. ... result of passthrough queries read/write instead of read only and also make ... database become corrupted when the users will start making their very own ... of ADP but what they are pushed toward is - how could I say that politely - ...
    (microsoft.public.access.adp.sqlserver)
  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)