>>Does anybody know why the timer events do not fire during an asynchronous SQLEXEC even though the commands in the loop that keeps issuing the command (checking for the complete return value) execute properly?
>>
>>The problem is that the timer events seem to either backup or not fire at all during the sqlexec command. Sometimes these queries can approach an hour and I like to have an animation running to indicate the app is 'Alive'. When animating the icon frame by frame in the loop, the timing is irradic due to network traffic, system speed, etc. I thought a timer based animation would be best solution.
>
>
>I thought there was some info on timers (problems?) in the MS Knowledge base.
>
>HTH,
>Tom
Thanks for the 'Quick' response! Nothing found on the WWW search of the KB dealing with this problem. It seems interesting that a loop like:
{timerclass.start}
lnSqlFinished=0
do while lnSqlFinished#1
lnSqlFinished=SQLEXEC(lnConnectionNumber,lcSelectStatement)
wait window 'Still Going...'+time() nowait
{additional commands}
enddo
wait window 'Sql Finsihed' timeout 1
{timerclass.stop}
would work because the select statement is running on the server and the resources of VFP are free to run the timer. In this case the timer events either (randomly?!) do not fire at all or execute all at once just before the 'Sql Finished' wait window appears.
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