Hi Germam,

I solve a similar problem using statement COMMIT to each 1000 inserts.

> ----- Mensagem original -----
> De: German Terrazas Angulo [SMTP:german@...]
> Enviada em: quarta-feira, 9 de abril de 2003 09:57
> Para: ib-support@yahoogroups.com; ib-support@yahoogroups.com
> Assunto: Re: [ib-support] firebird insertion error
>
> hi,
>
> It seems to... but I have a prepared statement.
>
> It works for 1 or 1000 inserts but it fails (rise that error) for 10000
> insertions.
>
> Any idea to solve the problem ?
>
> thanks,
> yerman
>
>
> At 10:28 PM 09/04/2003 +1000, Helen Borrie wrote:
> >At 09:16 AM 9/04/2003 -0300, you wrote:
> > >hi,
> > >
> > >I need to perform insertion of 10000 rows into 5 different tables in an
> > >opened transaction (auto commit = false). But while it runs firebird
> > generate
> > >
> > >GDS Exception, invalid request handle
> > >
> > >before reach commit command line.
> >
> >It seems as if you have an unprepared statement somewhere there.
> >
> >heLen
> >
> >
> >
> >
> >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/
>
>
>
> 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/
>