Ok - it seems that fetch from the MB window simply wasn't going to work out. I guess it didn't like the various commands I issued in between fetches. I ended up using the MB window to instead loop through each row using the rowid, select the record, perform my stuff, then incrementing a rowid alias to get the next record. It tripled the amount of code, but at least it works. I'll share more details if anyone else needs help with this kind of thing.
Thanks to all who responded. D -----Original Message----- From: Darrin Clement [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:40 PM To: Mapinfo-L Subject: MI-L fetch next is skipping records Sorry - This is a follow-up to this morning's question. It turns out that what is actually happening is that the [fetch next] command seems to skip records. It happens on any table I use, no matter what the source. Even an Excel table we created as a test. We have packed the table and also tried indexing on the field we are fetching from (neither changed the effects). The MapBasic manual says that certain commands may "reset" the cursor but that's not what's happening here - it's skipping records in a very random pattern. This seems weird. Anyone have a clue? Thanks! ******* Darrin ------------------------------------------------------------ --------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
