No results in detail table, when master field is NULL

[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

[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)

[FrankS]

Thank you for your quick reply!

[AlexP]

Hello,

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