Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
- Posts: 299
- Joined: Thu 12 Oct 2006 09:34
Hi, do you have a recommended way to process all records in sorted dataset? Especially how to handle the situation, when the field, that is included in indexfieldnames, has to be changed.
typically, such code does not process the whole dataset, but only the (initially) first record - because with the first ".post" it jumps to last position (because of active sorting) and the next ".next" call activates eof and the iterations stops.
Code: Select all
dataset.indexfieldnames := 'somefield';
while not dataset.eof do begin
datasetsomefield.asinteger := maxint;
Thanks for ideas. I have the only one - set indexfieldnames before this iteration to empty string, but i don't find this nice...