German,

> Tim wrote:
>
> > /* Stored procedures */
> >
> >CREATE PROCEDURE "GETFIELDS"
> >(
> > RECORDNUMBER INTEGER
> >)
> >RETURNS
> >(
> > FIELDA VARCHAR(128) CHARACTER SET ASCII,
> > FIELDB INTEGER
> >)
> >AS
> >
> >BEGIN
> > FOR SELECT FIELDA, FIELDB FROM TABLE1
> > WHERE
> > RECORDNO = :RECORDNUMBER
> > INTO
> > :FIELDA :FIELDB
> > DO
> > BEGIN
> > SUSPEND;
> > END
> >END
> >
> >
> But i need to return a set of records, not a single record.

Additional to Tim's answer.

PSQL, the procedural language used for writing stored
procedures and triggers is easy to learn, but you need
something to start with.

You might get more productive if you check out the
following things:

- http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_intro_sp_trig
- InterBase 6 Beta Documentation:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_documentation
- Additional to two mentioned above, check out the
Firebird 1.5 release notes, if you are using 1.5,
because there were quite some enhancements for PSQL

The latest and greates all-in-one documentation, also
covering stored procedures and triggers, is either
Helen's book or the PDFs on the IBPhoenix CD.

Helen's book:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_firebird_book

IBPhoenix CD:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_cd


HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com