Board index » delphi » Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)

Ramon Mendiguren

Delphi Developer
Fri, 16 Sep 2005 20:50:34 GMT

Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)

Hi:

I want to put two query like master-detail working with Oracle, and when I
tried to open the query there is an error if the query has requestlife
property to true. If I use a Interbase DataBase it runs all right, So I
suposse that Oracle will be posible, isn't it?

sqlora8.dll    version 5.1.0.6

thanks

 
Eric Hil

Delphi Developer
Fri, 16 Sep 2005 23:09:51 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


So, what's the error?

Quote
"Ramon Mendiguren" <ramonme...@euskalnet.net> wrote in message

news:3e883a1e$1@newsgroups.borland.com...
Quote
> Hi:

> I want to put two query like master-detail working with Oracle, and when I
> tried to open the query there is an error if the query has requestlife
> property to true. If I use a Interbase DataBase it runs all right, So I
> suposse that Oracle will be posible, isn't it?

> sqlora8.dll    version 5.1.0.6

> thanks

Ramon Mendigure

Delphi Developer
Sat, 17 Sep 2005 14:35:48 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


The error is "Table doesn't exist"

"Eric Hill" <e...@ijack.net> escribi en el mensaje
news:3e885a4e$1@newsgroups.borland.com...

Quote
> So, what's the error?

> "Ramon Mendiguren" <ramonme...@euskalnet.net> wrote in message
> news:3e883a1e$1@newsgroups.borland.com...
> > Hi:

> > I want to put two query like master-detail working with Oracle, and when
I
> > tried to open the query there is an error if the query has requestlife
> > property to true. If I use a Interbase DataBase it runs all right, So I
> > suposse that Oracle will be posible, isn't it?

> > sqlora8.dll    version 5.1.0.6

> > thanks

Kevin Frever

Delphi Developer
Sat, 17 Sep 2005 21:33:20 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


Ramon,

I'm not sure about Oracle, but when using RequestLive, table names are
case-sensitive.

Good luck,
krf

Quote
"Ramon Mendiguren" <ramonme...@euskalnet.net> wrote in message

news:3e8933c9@newsgroups.borland.com...
Quote
> The error is "Table doesn't exist"

Robert Cern

Delphi Developer
Sat, 17 Sep 2005 23:51:38 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


Not exactly.
With RequestLive=true, BDE quotes table name.

On Oracle table names are case sensitive. If you do a
select * from ATable, server will try to get best match (guess what happens
if you have "atable", "Atable", "ATabLE" and some other idiotic variations),
but if the table name is quoted,
select * from "ATable", server will search exact match.

--
Robert Cerny

Quote
"Kevin Frevert" <ke...@workdrinkingcoffee.com> wrote in message

news:3e899522$1@newsgroups.borland.com...
Quote
> Ramon,

> I'm not sure about Oracle, but when using RequestLive, table names are
> case-sensitive.

> Good luck,
> krf

> "Ramon Mendiguren" <ramonme...@euskalnet.net> wrote in message
> news:3e8933c9@newsgroups.borland.com...
> > The error is "Table doesn't exist"

Kevin Frever

Delphi Developer
Sun, 18 Sep 2005 01:43:23 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


Just curious, you cannot use RequestLive against Oracle because of this
"feature"?

krf

Quote
"Robert Cerny" <robert.qwe.ce...@neosys.xrs.qwe.si> wrote in message

news:b6cjjb.2ko.1@neosys.xrs.si...
Quote
> Not exactly.
> With RequestLive=true, BDE quotes table name.

> On Oracle table names are case sensitive. If you do a
> select * from ATable, server will try to get best match (guess what
happens
> if you have "atable", "Atable", "ATabLE" and some other idiotic
variations),
> but if the table name is quoted,
> select * from "ATable", server will search exact match.

> --
> Robert Cerny

Robert Cern

Delphi Developer
Sun, 18 Sep 2005 19:52:23 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


Did I mention or anyhow imply it?
Don't think so. This feature just forces you use exact case object names in
case sensitive databases and prevents potential nonrepairable damage. It is
a feature - no quotes needed.

--
Robert Cerny
http://codecentral.borland.com/codecentral/ccWeb.exe/author?authorid=...

Quote
"Kevin Frevert" <ke...@workdrinkingcoffee.com> wrote in message

news:3e89cfbf@newsgroups.borland.com...
Quote
> Just curious, you cannot use RequestLive against Oracle because of this
> "feature"?

> krf

> "Robert Cerny" <robert.qwe.ce...@neosys.xrs.qwe.si> wrote in message
> news:b6cjjb.2ko.1@neosys.xrs.si...
> > Not exactly.
> > With RequestLive=true, BDE quotes table name.

> > On Oracle table names are case sensitive. If you do a
> > select * from ATable, server will try to get best match (guess what
> happens
> > if you have "atable", "Atable", "ATabLE" and some other idiotic
> variations),
> > but if the table name is quoted,
> > select * from "ATable", server will search exact match.

> > --
> > Robert Cerny

Kevin Frever

Delphi Developer
Mon, 19 Sep 2005 21:23:19 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


When I replied to Ramon stating when using RequestLive table names are case
sensitive you wrote..

Quote
>Not exactly.
>With RequestLive=true, BDE quotes table name.

Then you wrote..

Quote
> > > On Oracle table names are case sensitive. If you do a
> > > select * from ATable, server will try to get best match (guess what
> > happens
> > > if you have "atable", "Atable", "ATabLE" and some other idiotic
> > variations),
> > > but if the table name is quoted,
> > > select * from "ATable", server will search exact match.

I was under the impression you meant the quotes were causing the problem (no
table named "ATable").

I'm not sure what was "Not exactly" right about my initial response, since
you turned right around and said table names are case-sensitive, but have a
great day anyway.

krf

Quote
"Robert Cerny" <robert.qwe.ce...@neosys.xrs.qwe.si> wrote in message

news:b6epuo.2uo.1@neosys.xrs.si...
Quote
> Did I mention or anyhow imply it?
> Don't think so. This feature just forces you use exact case object names
in
> case sensitive databases and prevents potential nonrepairable damage. It
is
> a feature - no quotes needed.

Robert Cern

Delphi Developer
Wed, 21 Sep 2005 19:47:04 GMT

Re:Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)


I'm sorry for misunderstanding.
With RequestLive=true, BDE quotes table name, which on case sensitive DB
means exact case matching. On case insensitive DB it usually means nothing.
Except that you can use table names with spaces.

That's why I wrote "not exactly", meaning that RequestLive=true means quoted
table name, but not necessarily case sensitive.

The problem is not cause by quoting, but by not knowing the fact that on
some DBs object names are case sensitive, yet they do best-match, if the
identifiers are not quoted.

--
Robert Cerny
http://codecentral.borland.com/codecentral/ccWeb.exe/author?authorid=...

Other Threads

1. BDE 5.11 - Oracle 8i

2. Calling Oracle 8i packaged procedures through BDE 5.11

3. Delphi3 C/S, BDE 5.11, Oracle 8i

4. BDE 5.11 - Oracle 8i

5. RequestLive=True causes Raise Exception to lose Oracle error details with TQuery

6. delphi 4 , bde 5.11 ,oracle 8.16 problems with Blobs

7. Problem with Delphi 5, BDE 5.11 and Oracle 8.1.7

8. Delphi 5 with BDE 5.11 and Oracle Client 7.3.4 General Protection Error

9. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

10. Oracle 8.1.7 and BDE 5.11 (Delphi 5)