tHANKS

I got it to work.
--- In firebird-support@yahoogroups.com, Ricardo Agüero Rodas
<raguero@u...> wrote:

> 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]