[fpc-devel] TField.FieldName: how about database and table names?

[Bram Kuijvenhoven]

Hi!

The TField class from the db unit defines a FieldName. When using SQL queries, columns in the result set can be fully qualified using the form 'database.table.field'. Apparently FieldName only constitus the latter part.

When using an SQL query like

  SELECT * FROM myTable AS t1, myTable AS t2

how should one distinguish between t1.aField and t2.aField when using TField?

Is there currently a feature for this in the data model, or should we perhaps add two additional properties -- DatabaseName and TableName -- to a TSQLField (and TSQLFieldDef) descendant? (which then could be used by SQLDB etc.)

Regards,

Bram