Thanks Steve. For some reason it seems to have righted itself, when I put the alias.RowID back. I don't understand why.
And as to using GoTo: I seem to recall something like that in the "Legends of the Dream-time People" :-) Thanks for the other tips too; I'll look into them. There is a "Fetch next" in the loop, of course; I just didn't bother including non-rlevant code in the message. Cheers Terry -----Original Message----- From: Nabors, Steve [mailto:[EMAIL PROTECTED] Sent: 21 December 2005 15:46 To: Terry McDonnell Subject: RE: [MI-L] What's up with RowID? I usually do something like this '**begin code*************** Select * from mytable into createcrush Fetch first from createcrush loop1: x = createcrush.rowid If (this or that) then End If fetch next from createcrush If not EOT(createcrush) then goto loop1 Else goto loopend End If loopend: '***end code************* _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
