General information
Category:
Coding, syntax & commands
>>>>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"
Any way to supress that message? I wouldn't want my users to press ESCAPE and cancel the process...
TIA
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only