How to use OrderFields with collate

BlueMoon · Post by **BlueMoon** » Tue 30 Mar 2010 19:13

Hi,

I want to migrate from IBX to IBDAC.

With IBX I use
IBTable.SelectSQL.Text := select * from MyTable order by MyField collate DE_DE

With IBDAC I want to use
IBCTable.OrderFields := MyField collate DE_DE

But it dosn't work. Error: Column unknown "MyField collate DE_DE"

Question 2: How does it work with two fields?
order by MyField_1 collate DE_DE, MyField_2 collate DE_DE

Best regards
Michael

Dimon · Post by **Dimon** » Wed 31 Mar 2010 07:46

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next IBDAC build.

BlueMoon · Post by **BlueMoon** » Wed 31 Mar 2010 12:17

What about nulls first? This should be possible too!

IBCTable.OrderFields := MyField nulls first

Or this (asc/desc sorting):

IBCTable.OrderFields := MyField asc nulls first

Is this possible in next version?

Dimon · Post by **Dimon** » Thu 01 Apr 2010 07:05

Yes, we have fixed these problems.