RE: Order By on a table

RE: Order By on a table

Mark,
i dont have any problem in send you OneWorld Xe Tools API Reference,
In my profile, in jdelist you have my email. Send me your mail and you
recieve it.

Anyway, i attach a business function where you can see how i execute this
sql sentence:
SELECT SDKCOO, SDDCTO, SDSHAN, SDADDJ, SDIVD,SDITM,SDLITM,SDNXTR,
SDLTTR,SDAEXP,SDDCT FROM F42119 WHERE SDIVD BETWEEN "value" AND "value"
ORDER BY SDSHAN,SDITM

You can see how i open the table, make the selection, make the sort and
finally execute it.
Then in a while loop i recieve all the sentence data.

Hope this help you.

PD: sorry for my english.

----------------------------------------------------------------------------
-----
B733 - SP 20_J1 / ES NT - W2K - ORACLE 8i / Clients - W98 , W2K Pro , XP Pro




This email may contain confidential material. If you were not an
intended recipient, please notify the sender and delete all copies.
We may monitor email to and from our network.


--------------------------------------------------------------------
--------------------------------------------------------------------
B733 SP11.2 -->SP 20 ORACLE 8.1.7 W2000

here is the attachment

Daniel,

Thanks for the sample c business function. This will help me alot.

Mark Potter