Is there such a thing as fetching records too fast? I am using a loop to
run through a table. I am trying something like this:

find_id = site100
nbr_recs = TableInfo(Sectors, 8)
For I = 1 to nbr_recs
    Fetch Rec I from Sectors
    s_id = Sectors.ID
    If s_id = find_id then
        do something
    End if
Next

Every time I get to record 2 I get a message Unknown Error. When the if
condition = trrue and it takes a minute to process something, there is
no problem, but if it jsut loops through and the if condition is not
true I get the error. It seems the delay in the processing lets the
program "catch up". Has anyone else experienced this?

BTW, I can't use the select and the use CommandInfo to get teh rowid,
because sometimes rows have been deleted. The CommandInfo function
always seems to not know this and if the selection has deleted rows
above it, they don't get counted.

Cameron



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to