On Monday 27 January 2003 11:31, HeLen wrote:

Hi,

> CREATE PROCEDURE insertRecord (In_Name varchar(10))
> RETURNS (out_ID integer)
> as
> begin
> out_ID = GEN_ID(gen_MyTable_ID, 1);
> INSERT INTO myTable (id, name)
> VALUES (:out_ID, In_Name);
> end ^
>
> Normally, we don't get the generator value this way.

I do <g>

Certainly in 2-tier apps, I normally have an add/edit/view/delete stored
procedure for each entity (e.g. Customer). It allows a very thin client, and
tends to make maintenance a lot easier IMO. But I suppose it depends on how
you develop your client app and what 'toolset' you use to connect to FB.

Phil
--
Linux 2.4.4-4GB
9:36am up 13 days, 15:25, 1 user, load average: 0.05, 0.02, 0.00