Page 1 of 1

No results in detail table, when master field is NULL

Posted: Tue 12 Nov 2013 14:07
by FrankS
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

Re: No results in detail table, when master field is NULL

Posted: Wed 13 Nov 2013 08:56
by AlexP
Hello,

Thank you for the information. We have reproduced and fixed the problem. This fix will be included to the next version.
For the time being, you can not specify the MasterField and DetailField parameters in detail DataSet, and add the following where section manually:

Code: Select all

WHERE DEPTNO = :DEPTNO OR (DEPTNO IS NULL AND :DEPTNO IS NULL)

Re: No results in detail table, when master field is NULL

Posted: Wed 13 Nov 2013 11:33
by FrankS
Thank you for your quick reply!

Re: No results in detail table, when master field is NULL

Posted: Wed 13 Nov 2013 12:02
by AlexP
Hello,

If you have any other questions, feel free to contact us.