>>>Hi,
>>>
>>>I'm using a basic loop to wait for new records to show up in a table. When a new record shows up, I process it and then wait for the next record to show up... sounds simple...
>>>
>>>But some records are slipping through un-detected. So of course, my totals are off. Interestingly, most (but not all) of the un-detected records are added by the same workstation.
>>>
>>>Any ideas why this might be happening? Any suggestions to improve this logic?
>>>
>>
>>Why not add this table to a database and add an Insert trigger to the table?
>>Then when a new record is added, the insert trigger automatically fires.
>
>I just thought of another point... the processing can take some time to complete (up to a full second). So what would happen if another record was added during that second?
>
>TIA
The second one will wait for the first one to get done, then it will fire.
You'll see a message in the VFP status bar or a wait window that says "Attempting to lock...Press ESC to cancel"
Insanity: Doing the same thing over and over and expecting different results.