question

gmi georges avatar image
0 Likes"
gmi georges asked anthony.johnson answered

Bug. Query not working.

strSQL = "SELECT * FROM EPF WHERE DateFab = '2016-10-26 06:06:10.073' AND Empl LIKE '0201%'";

It seems that AND is not working. Interpreted as OR

FlexSim 17.1.0
query
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

anthony.johnson avatar image
2 Likes"
anthony.johnson answered

Thanks for this report. This is actually a bug in the LIKE clause, introduced with 17.1. We'll get this fixed for the next bug fix release.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.