I am using a small host app to do routine tasks like pricing when multiple users add or modify data, so the users work on a small transaction file, and ONLY the host app opens history, pricing etc.

My problem is, the app doesn't seem to "see" the new records as fast as I think it should!

The users "flush" after any modifications, but the host app doesn't immediately see the change despite go top/go bottom, locate for, etc. No forms or grids in use, just test for conditions & CASE in the app, users are submitting HTML or parameters to a foxisapi method.

This is a WebConnect/foxisapi environment, so a lot of things are happening out of sight of my own code. It all works, but tends to take 5 to 10 seconds, which is a nuisance since the foxisapi & webconnect sessions are 'busy' waiting!

typical code on the app

do sleeper && win API sleep
select transactions
go bott
go top
locate for NEW
IF FOUND()
DO CASE
*!* various udfs
ENDIF

thanks

mike