I saw this a while back in an Access table. I assumed it was a bug between MB and Access. I use the fetch rec n now and don't have a problem. I don't think you can use this via the MB window though. Hope you find a solution.
Cameron Darrin Clement wrote: > 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]
