Page 1 of 1

Oracle provider and FieldsQrigin

Posted: Mon 24 Nov 2008 06:58
by burdian
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

Posted: Mon 24 Nov 2008 09:39
by Plash
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.