Cursor: Derived column referencing

[Darren Reely]

Dan,

Thanks for the idea.  I tried it.

Unfortunately, although the Powerhouse SQL log shows the 'Order By'
statement made it intact as 'ORDER BY 1, TEST_FACILITY, PROD_LINE, BIN_ID,
MS, LOT_ID', Quick/Oracle is not acting on it.  It is ignoring the first
column in the 'Order By' statement, so starts the sort from TEST_FACILTIY.

I've converted the statement to SQLPlus code and it works fine, of course.

Blue (Robert Edis) suggested trying stored procedures for both my cursor
problems.  I'll have to find some time to learn this after this project is
done.  Thanks Blue.

Darren.


Dan Osborne wrote:
> 
> Darren,
> 
> Have you tried refering to the column by position instead of name i.e. order
> by 1 if it is always going to be the first column?
> 
> Dan Osborne
> Specialist Business Solutions Ltd.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.