You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This statement
select * from NOMINAL_LEDGER where NOMINAL_CODE = ? order by NOMINAL_CODE
works as expected
This statement
select * from NOMINAL_LEDGER order by NOMINAL_CODE where NOMINAL_CODE = ?
returns "Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column 23 where"
It seems that "order by" cannot be used before "where". This gives a problem with TSQLTable generated SQL in Delphi 2006
The text was updated successfully, but these errors were encountered:
ORDER BY clause *is really* (and *by design*) cannot be used before WHERE. This is the standard SQL syntax. Blame your toolset for ignoring such a well-known rule.
Submitted by: Leslie Kaye (leskaye)
This statement
select * from NOMINAL_LEDGER where NOMINAL_CODE = ? order by NOMINAL_CODE
works as expected
This statement
select * from NOMINAL_LEDGER order by NOMINAL_CODE where NOMINAL_CODE = ?
returns "Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column 23 where"
It seems that "order by" cannot be used before "where". This gives a problem with TSQLTable generated SQL in Delphi 2006
The text was updated successfully, but these errors were encountered: