Skip to Content
0
Former Member
Feb 22, 2011 at 09:48 AM

SQ02 - Issue on a infoset which doesn't order the results

1033 Views

Hello to everyone,

I'm experiencing some issues when creating a Infoset and implementing the relative query, as the results aren't ordered by the first field which is the Primary Key of the first table of the join which composes the Infoset. Here are the details:

I've created a query on the following JOIN:

DFKKKO >> ERDB >> ERCHC

Plus, i've implemented some code to mess the query so that it returns some additional field with custom values.

One of the target of this query is to have the output sorted by DFKKKO-OPBEL, which is the key of DFKKKO, but it seems that when I ask for a big amount of data, the output isn't sorted at all.

Is there a way to ask the infoset via SQ02 or the query via SQ01 or some coding within the additional fields, etc.. to sort the output by certain fields? In this particular case, I'd like to order for the first output field which is the key of the first table of the join.

Thank you very much in advance.

Best regards,

Claudio