>That's a tricky question. Every SELECT-SQL results in a table as the source...either the direct source table or a temporary table.
>
>Can you tell more specifically what you are needingt o do?
>
>>What's the best way to determine if a cursor is a table or the result of a Select Into?
I have a VCR class that will allow you to do a 'set order' on the table. when I use the class with a 'select into' result the set order will produce an error. That's why I want to check the source.
The solution suggested by Dore Svei using the 'JustStem' does the job. I didn't even this command existed. Thanks to both of you.
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108