We solve that problem with 2 stored procedure. Not a reasonable example, but a example that demonstrate how you can do it:


-= PROCEDURE1 =-
FOR SELECT ORDERNR FROM ORDERS INTO :ORDERNR DO
BEGIN
SUSPEND;
END

-= PROCEDURE2 =-
SELECT ORDERNR FROM PROCEDURE1 ORDER BY ORDERNR


Hope that helps!

Best wishes,

Marc Geldon

-----Ursprüngliche Nachricht-----
Von: petdevis [mailto:devis@...]
Gesendet: Dienstag, 27. Januar 2004 16:03
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] temporary tables


I would like to sort some values inside the body of a stored
procedure.Those
values are collected from differed tables . Does the Firebird support
Temporary tables (visible only inside the user's opened transaction)
(like
oracle does)?
If not , is there some data type (like array ) to use for sorting the
data

Thanks
PD



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]