Look here:
http://www.cvalde.com/ibDocumentation.htm


Guido

Marco Lauria wrote:

> At 09.53 09/05/2001 -0400, you wrote:
>
> > >At 11:17 AM 09-05-01 +0300, Dorin wrote:
> > > >Hi everyone !
> > > >How can I update a table in a SP using a FOR SELECT ... clause ?
> > > >
> > > >FOR SELECT <some columns> from <table> into <vars> DO BEGIN
> > > > ... Here is the updating part ...
> > > >END
> >
> >At 10:07 PM 5/9/2001 +1000, Helen Borrie wrote:
> >
> >
> > >In a FOR SELECT loop on one table you can use the selected data to update
> > >another table but not to update the one which is the subject of the
> > loop, e.g.
> >
> >Helen must have been having an off day.
> >
> >Something like this will work:
> >
> > for select <primary key> from <table> where <condition>
> > into <variable>
> > do begin
> > update <table> set <assignments> where <primary key> = <variable>
> > end;
> >
> >There are a couple of variants that might be slightly faster (using
> >the undocumented cursor mechanism or db_keys) but as all the structures
>
> which is this?
> where can I get some informations about this undocumented mechanism?
> Regards
> Marco Lauria
>
> 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/