7 May
2012
7 May
'12
3:43 p.m.
Dear All! My old problem http://sourceforge.net/mailarchive/message.php?msg_id=29168305 strikes back on the new version. The situation is just the same - combination of two conditions gives empty result (that is wrong), while each condition alone gives correct resultset. The problem shows up only in the SECOND run of quite a huge set of queries (the first one runs Ok). Even more, there has to be some delay (~10 sec) before the second run, otherwise everything works. Deleting all records does not help, problem disappears only if I recreate the table. What on Earth can this be? It seems rather hard to pin down the problem with SQL-methods only. Just in case - I attach traces of correct and incorrect queries. Regards, Alexey Mints