Incorrect record order in RDO Resultset

[LRW]

I am opening a RDO Resultset with data returned from a Sybase stored procedure. The problem is that the order of records in the Resultset is not always correct. However, when I run the stored procedure from an SQL prompt, the order is always correct.

I have successfully done similar things in other parts of the code. The main difference here is that the stored procedure creates a temp table from which the results are returned.

Has anyone encountered something similar?

 

[Snaggs]

Correct me if I'm wrong, but it sounds like the the stored proc is creating/adding records to a temp table, and then you're reading the records from the temp table.

It's posible that you have an order by clause on your statement that creates the records in the temp table, but not an order by to retreive the records from the temp table.

I'd need more information on what the proc does if this response does not help you. Snaggs
tribesaddict@swbell.net
Life can only be understood backwards; but it must be lived forwards.