Devart Forums

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

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

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?

Yes, we have fixed these problems.