Oracle provider and FieldsQrigin

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Oracle provider and FieldsQrigin

Post by burdian » Mon 24 Nov 2008 06:58

Hi,

UniQuery with Connection.ProviderName=Oracle, Options.FieldsOrigin = True.
After Open only fields from primary table (select .. from) has Origin with TableName.FieldName, fields from other tables has Origin with FieldName only.
Is this little bug or is impossible to get TableName with Oracle?
I need TableName because of my Data Dictionary (not Oracle DD).

With Interbase and MSSql providers thre is no problem with Fields Origin.

TIA and Best regards
Branko
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 24 Nov 2008 09:39

In most cases Oracle provider can detect the table name for all fields. But if table name cannot be detected, it is not set in the Origin property.

There is no problem with SQL Server and InterBase providers because corresponding servers send information about tables with the query results.
Top
Post Reply

Return to “Universal Data Access Components”