4.40.0.24 : #42000 Syntax error near 'Where Id = Null' at line 1

[swierzbicki]

Hi,

This is not a big deal (as there is a simple workarround), but it looks like the parser doesn't treat the ';' delemiter of the detail query.

Steps to reproduce :

Drop 1 Connection, 2 queries , 2 datasource.
Set connection on both queries
Set dataset on both datasources

Code: Select all

SQL For Master Query :
Select
0 as Id;

Code: Select all

SQL For Detail Query :
Select
1 as DetailId,
0 as Id;

Make a Master Detail relation ship between the 2 queries.
Open the Detail Query :

act : #42000 Syntax error near 'Where Id = Null' at line 1
Exp : this should works

Workarround : remove the ';' from the detail query. It looks like the MyDAC parser doesn't take care of the last ';'

[Jackson]

Thank you for information.
We have reproduced the problem and fixed it.
This fix will be included in the next MYDAC build.