Devart Forums

Using the IBExpert:
select N.NUMERO from TESTE N order by cast(N.NUMERO as begint);
or ... order by lpad(N.NUMERO, 20, '0')
works perfectly.
But with D2009 + DbxIda 2.50.22 = does not work.
Please some advice / suggestions?

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Now I became ill.
Under Development app and a small table with data to send them, found that it works properly.
Then, more motivated, reviewed in detail the lines of code in the app and also use the table, and finds nothing wrong. However, no ordering appropriately (ordered alphabetically, but not ordering as bigint).
Any suggestions?
Thank you.

Ok, I found the problem:
set was missing in poRetainServerOrder = True no DataSetProvider.
is solved.

It is good to see that this problem has been solved.