Don Seiler writes: > I was considering this, but just thought it would be easier to just set > the flag in an aux structure and loop through my original recordset again, > checking the flag each time. > > Anyone know if there is a definitive yes/no on this?
There are various issues to consider, but they depend on your specific situation. First, if the number of records that are going to match your criteria is limited, then I'd definitely just push these to an array. Going through the record set a second time is potentially a problem if the records that match your criteria are likely to change between runs (if there are updates between the runs, for example). That said, why can't you use the WHERE clause to effectively retrieve the rows that match your criteria and avoid the problem? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
