No results in detail table, when master field is NULL
Posted: Tue 12 Nov 2013 14:07
Hello,
I'm using Delphi XE 4 with a Firemonkey form connected to a SQLite database and I have the following problem:
I have two tables connected by a master-detail relationship.
LiteQuery fails to populate the detail table, when a master field is NULL. Is there any possibility to show these records in the detail table (where the master's field value corresponds to the detail's field value in being NULL)?
Thanks for any ideas!
Frank
I'm using Delphi XE 4 with a Firemonkey form connected to a SQLite database and I have the following problem:
I have two tables connected by a master-detail relationship.
LiteQuery fails to populate the detail table, when a master field is NULL. Is there any possibility to show these records in the detail table (where the master's field value corresponds to the detail's field value in being NULL)?
Thanks for any ideas!
Frank