SetOrderBy() Bug ?

tinof · Post by **tinof** » Wed 04 Jun 2008 12:26

Hi,

i'm just walking first steps with unidac, migrating a project from SDAC.

Please, try with TUniQuery (abstract)

...
UniQuery1.SQL.text := 'SELECT * FROM DEPT WHERE DEPTNO > 10 ORDER BY DEPTNO';

UniQuery1.SetOrderBy('LOC');

UniQuery1.Open; // causes an Error

// because SQL is now 
// 'SELECT * FROM DEPT order by loc WHERE DEPTNO > 10 ORDER BY DEPTNO';

Do i something wrong or ist this a bug (SDAC did substitute existing Order By clauses) ?

Thanks
Tino

Edit:
... never do 2 changes at once ..
I used until today SDAC 3.8 : here the ORDER BY Clause was substituted.
The shown problem is in SDAC 4.5 AND UniDac 1 .

Plash · Post by **Plash** » Thu 05 Jun 2008 07:08

We have fixed this problem. The fix will be included in the next build of UniDAC and SDAC.

tinof · Post by **tinof** » Fri 06 Jun 2008 05:36

Thanks,

when the next build will be available ?

Plash · Post by **Plash** » Fri 06 Jun 2008 07:14

We are planning to release new builds of UniDAC and SDAC at the beginning of the next week.