Toad World® Forums

UE Updateable Order


#1

SELECT * FROM rxl_idr_qp_list_headers ORDER BY 2

It retrieves the data order by the second column, as it should.
But, if you click on “Updateable”, and run the same query, it is not sorted correctly (not sorted at all).

The old SQL Editor did sort it correctly, even if you are in Updateable mode.

Thanks.
-Charlie

If you run the following:


#2

Hi Charlie,

I was able to reproduce your issue, although not immediately. Normally, it works OK. The problem is, I think, because the table name contains an underscore! This causes an error in the internal parser’s logic and drops the rest of the statement. Good catch! I’ll make a fix right now.

Roman

PS. BTW were you able to commit records at all? I didn’t see your reply to the other thread.

Message was edited by: roman