Hi,

I have a problem about a order by for a array in query, Can someone help me? I do this query and it results an error 302 of sqL when i run it.

select
whina124.amtf(1), | Montant De
whina124.itmt | Article A
from
whina124 | Transactions d'intégration de stock

order by
whina124.amtf(1)

The following should work:


select whina124.amtf(1), | Montant De
whina124.itmt | Article A
from whina124 | Transactions d'intégration de stock
order by 1

Thanks, I'll try to make this syntax but it result the same error.

Error : SQLState 42i47/ Order by array column not allowed(error 302)(main() in object ottadv3180parse).

That seems strange. Normally you should only get this error message on ERP LN (not BaanIVc), and only if you did, e.g., "select whina124.amtf ... order by whina124.amtf", so without the "(1)" index.

Which version are you using: BaanIVc? ERP LN? Other? Where are you entering this query? Are you sure you're using exactly the correct query? Could you retry without the comments?

hai all,
I am also facing the same issue, here i want sort the ticpr007.emtc field which was array field, I need to sort that.is there any solution for it.

SELECT ticpr007.emtc
FROM ticpr007
WHERE ticpr007.item = :tdpur401.item
SELECTDO
exsh_v = exsh_q * ticpr007.emtc(1)
ENDSELECT
thanks in advance.
please post quick reply.....................