F
Fabian Schueler
Guest
This issue was already filed as case number 00389055 but was not considered a bug, so I post this here now. I used the -Dsrv qt_debug,SQL parameter when connected to an MSSQL-DB to have a look at the executed SQL-statements. When using FOR FIRST/LAST, the SQL-statement that are generated always beings with SELECT TOP 1 [...]. When using FOR with no additional qualifier, the generated SQL-statement does not contain the TOP 1-phrase. It should though, since right now FOR is slower (tested) than FOR FIRST for this very reason. TOP 1 should be part of every FOR-statement except FOR EACH. The compiler already ensures that there is at max. one record to meet the criteria, which is why I personally use FOR without further qualification if possible.
Continue reading...
Continue reading...