Hi, a got this script =

before.program:
query.extension = "(tdsls040.cblc <> 0 and " &
"(exists (select tccom010.cnpa " &
"from tccom010 " &
"where tccom010._index1 = {tdsls040.cuno} " &
"and tccom010.cnpa <> tccnpa.blocked)) and " &
"(exists (select tcmcs042.blcs " &
"from tcmcs042 " &
"where tcmcs042._index1 = {tdsls040.cotp} " &
"and tcmcs042.blcs <> 0))) or " &
"(exists (select tdsls044.cblc " &
"from tdsls044 " &
"where tdsls044._index1 = {tdsls040.orno} " &
"and tdsls044.cblc <> 0))"


i'd like to know if there is a way to order that query, for example, order by tdsls040.cuno?? because, this Query, orders the information by sales order number, and that is not what i want...

any ideas??

i have baan iv c4

Thanks

The STP displays data in order by current key.

If there is any secondary index available on customer no field then you can use to.key() function to change the current key.