Re: ESQL/C cursor looping

Hi, A regular cursor does not get the rows. The list is static in both cases. Bill } } Allen W. Jantzen wrote: } > ******************************************************************************* } > Also: } > If a row is added to a table while I am in the middle of cycling } > through a cursor for that table, will I see the new row in my loop??? } > } > Or does the cursor only "see" rows that were present at the time of } > the OPEN??? } > } > Any help appreciated. } } Good question! Going from memory, (Keep in mind I have altzheimers(?sp) } ;-) .... } A scroll cursor will have a static list of rows. I think it occurs } either at the open statement or the first fetch. } } I think that the regular cursor will get the new rows, but I am not } sure. } } -Mikey } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com