Devart Forums

Posted: **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 .

Posted: **Thu 05 Jun 2008 07:08**

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

Posted: **Fri 06 Jun 2008 05:36**

Thanks,

when the next build will be available ?

Posted: **Fri 06 Jun 2008 07:14**

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

Devart Forums

SetOrderBy() Bug ?

SetOrderBy() Bug ?