just installed latest clarion 11.1.13768 and dyna drv and I have a situation where prop:SQL fails with complex structures ( select * or joins with table name substitute). Everything was fine in Clarion 11. Just now opened and compiled with clarion 11.1
My findings show that if I use claODB.dll ver 22.214.171.12430 all works with Clarion 11.1.13768, however if I use claODB.dll ver 11.1.13758 or 11.1.13744 then I get error executing the same sqlstatement:
HY000-Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 124
I was wondering if anyone else get into problem like I. I dont want to keep using prior release of claodb.dll file. SQL is 100% valid as it works when I execute it in database workbench.