Subject Re: [IBO] Unidirectional Cursor
Author Lucas Franzen
Bill Morrison schrieb:
> What would be the best IBO component/settings to do something like :
> prepare;
> first;
> while not eof do
> {read field values, and store elsewhere}
> next;
> close;
> I'm processing a lot of large records, and don't need the data to remain in
> memory after I go to the next. I've tried out a few, but can't seem to get
> the results I'm looking for.

Have you tried a TIB_Cursor and using the APINext method (instead of
Next) for doing so?

I've got very good performance with using Cursors for reading data and
TIB_DSQL statements (INSERT / UPDATE) for saving.