4.40.0.24 : #42000 Syntax error near 'Where Id = Null' at line 1
Posted: Thu 29 Mar 2007 13:44
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
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 ';'
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;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 ';'