> I use your TIP_Scrips1 component to do updates on my database (interbase). I
> can do all kind op updates, but this one failes:
>
> CREATE PROCEDURE SET_KODE RETURNS (
> NEW_KD INTEGER
> ) AS
> BEGIN new_kd=gen_id(GEN_TEST,1); END;
> commit;
>
> The error: 'unexpected end of command'. When I execute the script file using
> isql.exe of wisql there is no problem at all. How can I add this procedure
> to my database using your command?

If you look at the above, you will notice that there are two
uses for ';' one in the procedure, and one to finish the
procedure. Look at the SET TERM command for scripts. This
allows you to change the 'outer' ';' to something else so
that the script engine does not get confused.

SET TERM ^
CREATE PROCEDURE SET_KODE RETURNS (
NEW_KD INTEGER
) AS
BEGIN new_kd=gen_id(GEN_TEST,1); END^
COMMIT^

Should work ( I think ;) )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services