mORMot Open Source

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

IsRowID fails with fully qualified field name: tableName.ID

with SQLite I've found that in order to combine MATCH queries UNION has to be used instead of OR. This has the side affect that the field names returned to TSQLTable also include the table name in the form: tableName.fieldName which breaks TSQLTable.IDColumnHide.

I can get round this by using 'select ... as ...' but would it be worth putting in a feature request for the IsRowID function to be extended to handle these cases?