Pete,
you can do that in MySQL but not here
Alan

-----Original Message-----
From: Pete Clark [mailto:computergenius@...]
Sent: Monday, 27 January 2003 10:27 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] converting MSSQL stored procedure to Firebird


In message <b132qs+gtu3@...>, tsangccn <tsang_cn@...>
<tsang_cn@...> writes

>Hello,
>
>I am converting stored procedure from MSSQL to Firebird,
>How to define the stored procedure in Firebird for
>a stored procedure in MSSQL as
>
>CREATE PROCEDURE insertRecord
> @name varchar(10),
> @id int output
>AS
> INSERT INTO myTable (name) values(@name)
> SELECT @id == @@IDENTITY
>GO
>
>Please Help.
>
>Thanks
>CN

I think that you are trying to make id as an auto incrementing number.
If this is correct, then you can make the field itself auto increment,
with something like
ID int(11) NOT NULL auto_increment

--
Pete Clark

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/