While all of your input was usefull, I figured out the problem on my own. I had no
deleted rows in this table just so you all know. For some reason, in the loop, if I
commited the table before I finish fetching all the records and updating then, the
next time I tried to
fetch a record after the commit, I got the error. I tried it on several machines and
got the same error every time. If I waited to commit the table until all updates were
complete, then there was no problem. I'm not sure I understand why, but it works.
Cameron
>
>
> -----Original Message-----
> From: Cameron Crum [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2001 01:00
> To: [EMAIL PROTECTED]
> Subject: MI-L Fetch
>
> 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.
>
> ********************************************************************
>
> This email may contain information which is privileged or confidential. If you are
>not the intended recipient of this email, please notify the sender immediately and
>delete it without reading, copying, storing, forwarding or disclosing its contents to
>any other person
> Thank you
>
> Check us out at http://www.syntegra.com
>
> ********************************************************************
_______________________________________________________________________
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.
