Page 1 of 1

setorderby Error

Posted: Fri 30 May 2008 07:24
by sbslavonac
Hi,
After installing new version 6.50.0.34 (Delphi 7)
setorder by puts 'order by' clause incorrectly

original Sql

SELECT dob.*, z.naziv_zemlje ,vs.opis
from dobavljac dob,vrsta_sklad vs, zemlje z
where z.zemlja=dob.zemlja and vs.vrsta_sklad=dob.vrsta_sklad

after setorderby

SELECT dob.*,dob.rowid, z.naziv_zemlje ,vs.opis
from dobavljac dob,vrsta_sklad vs, zemlje z
ORDER BY poduzece
where z.zemlja=dob.zemlja and vs.vrsta_sklad=dob.vrsta_sklad


Boris
Ibis Informatika

Posted: Fri 30 May 2008 07:27
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.