Hi Robert:



If you are in some script executive panel:



Select c1, c2, c3

From table

Order by c1 …. Should work !!



If you area using a stored procedure:



For Select c1, c,2, c3

From Table

Order by c1

Into :outpu1,

:outpu2,

:output3

Do

Begin

Suspend;

End ….. should work



I hope this helps you.





Ricardo Agüero Rodas









_____

De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] En nombre de Fr. Robert Bower
Enviado el: Jueves, 02 de Junio de 2005 09:19 p.m.
Para: firebird-support@yahoogroups.com
Asunto: [firebird-support] newbie procedure question



Excuse the newbie question but how does one right a select procedure
that returns data based on a sql statement. I've tried put I'm not
getting anywhere.

The sql statement is

FOR SELECT LOCATION_ID, LOCATION_DESC FROM TBL_LOCATION ORDER BY
LOCATION_DESC


Thanks

Fr. Robert




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





_____

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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



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