RequestLive = True fails if Sybase Name Full (db.dbo.table)

Robert Love

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

RequestLive = True fails if Sybase Name Full (db.dbo.table)

If your SQL statement uses the following,

select * from Database.dbo.TableName and you try to set REQUESTLIVE
to true it will fail, if you specify, select * from TableName it works
fine. However, if you have logged into another Database you
need to specify database.dbo.tablename for SQL to execute. Basically
it looks like the BDE does not know how to parse a SQL statement that
has more than one "." in it.

Can anyone else confirm this?

Robert Love

RAMESH THEIVENDRA

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:RequestLive = True fails if Sybase Name Full (db.dbo.table)

Yes, you are correct. SQL parsing engine expect ownername.tablename and
doesn't handle more that one period.
Try quoting the whole object name like "db.dbo.table" and it should work.

T.Ramesh.

Quote

Robert Love wrote:
> If your SQL statement uses the following,

> select * from Database.dbo.TableName and you try to set REQUESTLIVE
> to true it will fail, if you specify, select * from TableName it works
> fine. However, if you have logged into another Database you
> need to specify database.dbo.tablename for SQL to execute. Basically
> it looks like the BDE does not know how to parse a SQL statement that
> has more than one "." in it.

> Can anyone else confirm this?

> Robert Love

Robert Lov

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:RequestLive = True fails if Sybase Name Full (db.dbo.table)

Thanks that did the trick.

Robert Love

Quote

RAMESH THEIVENDRAN wrote:

> Yes, you are correct. SQL parsing engine expect ownername.tablename and
> doesn't handle more that one period.
> Try quoting the whole object name like "db.dbo.table" and it should work.

> T.Ramesh.

> Robert Love wrote:

> > If your SQL statement uses the following,

> > select * from Database.dbo.TableName and you try to set REQUESTLIVE
> > to true it will fail, if you specify, select * from TableName it works
> > fine. However, if you have logged into another Database you
> > need to specify database.dbo.tablename for SQL to execute. Basically
> > it looks like the BDE does not know how to parse a SQL statement that
> > has more than one "." in it.

> > Can anyone else confirm this?

> > Robert Love

Other Threads

1. Delphi->Sybase, dbo.Table problem

2. RequestLive=FALSE vs RequestLive=TRUE

3. RequestLive=TRUE vs RequestLive=FALSE

4. Upsizing and Table Names - dbo.xxxx

5. SQL 6.5 Why table name = dbo.employee???

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

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

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

9. Sybase table naming ?, Table not found!

10. Detail table operation failed <Table Name>