How to acquire fields origin from TSQLQuery
Posted: Fri 10 Jan 2014 16:16
Hello,
is there any suitable/reasonable/recommended way how to get information about fields origin from opened/prepared TSQLQuery? In case that SQL command joins data from two or more tables, moreover - when aliases are used for columns - how to detect real table/field name for every column in query?
There is Origin property inside of Db.TField class, but - if used with dbExpress dataset - it is always empty, with no value. Is this general behavior of dbExpress framework, dbExpress never care about origin of fields? Or is it driver-related issue?
TUniQuery component from UniDAC framework has Options.FieldsOrigin property (default FALSE). When set to TRUE, after opened/prepared, every field has non-empty value for its Origin property, formatted as TABLENAME.FIELDNAME. This is right behavior what Im looking for.
Thanks.
is there any suitable/reasonable/recommended way how to get information about fields origin from opened/prepared TSQLQuery? In case that SQL command joins data from two or more tables, moreover - when aliases are used for columns - how to detect real table/field name for every column in query?
There is Origin property inside of Db.TField class, but - if used with dbExpress dataset - it is always empty, with no value. Is this general behavior of dbExpress framework, dbExpress never care about origin of fields? Or is it driver-related issue?
TUniQuery component from UniDAC framework has Options.FieldsOrigin property (default FALSE). When set to TRUE, after opened/prepared, every field has non-empty value for its Origin property, formatted as TABLENAME.FIELDNAME. This is right behavior what Im looking for.
Thanks.