Board index » delphi » TQuery.RequestLive := True: Always get Table Not Found Error

Mike Myers

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

TQuery.RequestLive := True: Always get Table Not Found Error

Hello

   I'm using a TQuery component (Delphi 3.02 Client/Server) to connect to an
ORACLE8 db on a
   Netware 5 Server using the Native BDE 5.01 ORACLE Driver.  When the
RequestLive property of
   the TQuery component is False, I can successfully execute any valid SQL
query and retrieve
   records for display in my application. When I change the RequestLive
property to True, Then
   open the TQuery, I always get a

   'Project CDSTest.exe raised exception class EDBEngineError with message
'Table does not exist
    ORA-00942 table or view does not exist'.

   error, and no records are returned.  As soon as I set the RequestLive
property back to False,
   the query executes with no problem.

   This occurs regardless of which ORACLE table I'm connecting to or the
application I'm running the
   Query from. I'm hoping this is just some simple property setting or BDE
configuration parameter
   that I've overlooked. I'd certainly welcome any suggestions.

   Thanx
   Mike mmy...@trilobyte.net

 
Michael Glat

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TQuery.RequestLive := True: Always get Table Not Found Error


Hi Mike,

Try prefacing your table name with the owner in your Query:

Select * from OwnerName.TableName

HTH

--
Michael Glatz
mgl...@caiso.com

Quote
Mike Myers wrote in message <776035$i...@forums.borland.com>...
>Hello

>   I'm using a TQuery component (Delphi 3.02 Client/Server) to connect to
an
>ORACLE8 db on a
>   Netware 5 Server using the Native BDE 5.01 ORACLE Driver.  When the
>RequestLive property of
>   the TQuery component is False, I can successfully execute any valid SQL
>query and retrieve
>   records for display in my application. When I change the RequestLive
>property to True, Then
>   open the TQuery, I always get a

>   'Project CDSTest.exe raised exception class EDBEngineError with message
>'Table does not exist
>    ORA-00942 table or view does not exist'.

>   error, and no records are returned.  As soon as I set the RequestLive
>property back to False,
>   the query executes with no problem.

>   This occurs regardless of which ORACLE table I'm connecting to or the
>application I'm running the
>   Query from. I'm hoping this is just some simple property setting or BDE
>configuration parameter
>   that I've overlooked. I'd certainly welcome any suggestions.

>   Thanx
>   Mike mmy...@trilobyte.net

Mike Myer

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TQuery.RequestLive := True: Always get Table Not Found Error


Quote
Michael Glatz wrote in message  >Hi Mike,

>Try prefacing your table name with the owner in your Query:

>Select * from OwnerName.TableName

Thanx for the reply, but I still can't return a live dataset. I always
include
the table owner in my queries as it prevents problems when other users run
the app. I'm guessing that somehow the query syntax is being changed when I
set the RequestLive to true, but I don't know why or how.
Jeff Overcas

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TQuery.RequestLive := True: Always get Table Not Found Error


Live dataset with the Oracle drivers require all your tables and column
names to be in all upper case or else it cannot resolve them resulting
in this message.

Jeff Overcash

Quote
Mike Myers wrote:

> Hello

>    I'm using a TQuery component (Delphi 3.02 Client/Server) to connect to an
> ORACLE8 db on a
>    Netware 5 Server using the Native BDE 5.01 ORACLE Driver.  When the
> RequestLive property of
>    the TQuery component is False, I can successfully execute any valid SQL
> query and retrieve
>    records for display in my application. When I change the RequestLive
> property to True, Then
>    open the TQuery, I always get a

>    'Project CDSTest.exe raised exception class EDBEngineError with message
> 'Table does not exist
>     ORA-00942 table or view does not exist'.

>    error, and no records are returned.  As soon as I set the RequestLive
> property back to False,
>    the query executes with no problem.

>    This occurs regardless of which ORACLE table I'm connecting to or the
> application I'm running the
>    Query from. I'm hoping this is just some simple property setting or BDE
> configuration parameter
>    that I've overlooked. I'd certainly welcome any suggestions.

>    Thanx
>    Mike mmy...@trilobyte.net

Mike Myer

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TQuery.RequestLive := True: Always get Table Not Found Error


Jeff

Many Thanks! Using all capital letters for the Table Name did the trick.
Most of the books and examples I have on SQL and ORACLE nearly always show
their query statements with capitalized SELECT & FROM and lowercase column
and tablenames, a convention I picked up myself. The couple of apps I wrote
using The UpdateSQL against a ReadOnly dataset worked well with lowercase
queries, so thinking of capitalizing my SQL statements was something that
probably would not have occurred to me. Thanks for saving me from a long and
frustrating weekend!

Mike   mmy...@trilobyte.net

Other Threads

1. POL: setting REQUESTLIVE=true produces TABLE NOT FOUND error

2. Cannot connect to Oracle 7.3.3 table using TQuery when RequestLive is true

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

4. TQuery(RequestLive=True) x TQuery.ExceSql (Update Query)

5. MS SQL Server - getting read-only query with requestlive=true

6. TQuery - RequestLive := true; Why Does This Happen

7. Problem with TQuery.Post w/RequestLive = True in Transaction

8. TQuery.CanModify = false when RequestLive = true

9. TQuery RequestLive = True

10. TQuery.RequestLive = TRUE giving strange behaviour