Re: Sorting Integer
In article <1993Feb18.215259.19895@informix.com> cortesi@informix.com (David Cortesi) writes:
>check the index.
>
>TRUNC is supported by at least the 4.1 engines for SQL.
>
>I would doubt it would be supported by ACE.
Au contraire, <whatever Bart says>... works just fine in Ace. Ace just
passes the majority of the SQL direct to the engine anyway.
>I know it is not supported by 4GL 4.1 (I just tried it).
I just tried it too, works just dandy. I did the following:
----------------------------------------------------------------------
database aland
main
define v1 integer, v2 integer
declare c1 cursor for
select col1, -(trunc(col1, -2) - col1)
from t1
order by 2foreach c1 into v1, v2
display "col1 = ", v1, " trunc = ", v2
end foreach
end main
----------------------------------------------------------------------
This works fine with 4.10.UE1. What didn't work for you?
--
Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland
"A leopard never changes his stripes" -- Vice President Al Gore