At 04:22 16/04/2004 +0000, you wrote:

>Hi there!
>I am new in the databse world.
>Usually i see in the documentation of interbase examples where a
>procedure getXXXCod call a one generator.
>How i can do if i want create a procedure that receive a parameter
>that will be passed to gen_id?
>
>some thing like this, i think:
>
>set term !! ;
>CREATE PROCEDURE getNextCode(genName char(20))
>returns result int;
>AS
>begin
> result= GEN_ID(genName, 1);
>exit;
>END;
>SET TERM ; !!
>
>So, i'm so sorry, because i tryed do that it didn't work.
>
>Help me please, because i am developing a software where a have
>about a hundred of generetors.
>
>Thanks! #8^p
>
>Ricardo Nakashima

Hi Ricardo,

Look for "Execute Statment" on FB 1.5 Release notes.

See you !


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004


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