#1 2015-04-17 16:28:05

alpinistbg
Member
Registered: 2014-11-12
Posts: 124

Incorrect handling of sub-select

Hi Arnaud,

I have recently found that the where clause in form CreateAndFillPrepare(Rest, 'Col1=? AND Col2 IN (SELECT Col3 FROM OtherTable WHERE Col4=?)', [Val1, Val2]) does not work. I think the internal parser doesn't handle that particular case, just 'X IN (V1,V2,...)' case.

Regards,

Offline

#2 2015-04-17 21:42:10

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,183
Website

Re: Incorrect handling of sub-select

With an external db, I guess?

But the virtual tables should handle such queries.

The best in such case is to use a direct SQL on the external db, or put the sub query in memory cache.

Offline

Board footer

Powered by FluxBB