Kenneth,

Thanks for posting the code back. I'm curious though how long your total BCP process is taking and how much it slows it down making the count(*) hit every .25 seconds. You might find the performance overall better if you set that poll interval time so that the count(*) query happens no more than say 100 times ie 1% although depending on the size of your thermometer and it's blip accuracy might allow you to use a much longer interval.

>This is how you can run monitor the progress of bulk copying data into an RDBMS database such as MS SQL Server from Visual Fox Pro. The general approach is to establish two connections to the RDBMS, one connection runs the bulk-copy event, hereafter “bcp”. The other connection is used to monitor the bcp event.

> = INKEY( .25 ) && This reduces the number of times per second, the monitoring request is sent to the SQL server.