Sorry, you have to use a script or e.g. IB_Query component to reset a
generator
Alan

> -----Original Message-----
> From: Tim Ledgerwood [mailto:tim@...]
> Sent: Tuesday, 13 May 2003 6:01 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] SET GENERATOR in a stored procedure
>
>
> Why can't I do this, and how would I achieve the same thing if I
> can't do it :
>
> ALTER PROCEDURE MYPROCEDURE
> (
> INPUT PARAMETER LIST
> )
> RETURNS
> (
> OUTPUT PARARAMETER LIST
> )
> AS
> BEGIN
> SET GENERATOR GEN_MYGENERATOR TO 0;
>
> .
> .
> .
> END
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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/
>
>
>