Hi, José!
I met this problem, too. I suggest you a different approach! I solved this problem with a timer. Users don't need exactly a progressbar, but they accept anything, which can show, that program works, and doesnot hangs forever! So I made a lowlevel timer, not a timercontrol, but an FLL function, which is fired at every events of VFP. (Timer control's timer events aren't fired during tableupdate, but VFP events are!) My timer func. check the elapsed time since last activity and if elapsed the e.g. 0.5 sec it change my progress indicator to another state. I use Moon state bitmaps shipped with VFP.
I agree with you, that progressbar is better, but how can you chack the current state of updating? _TALLY doesnot show it. If it would does, with my timer you can update the your progressbar.
BB
p.s.: I you need I send mytimer.fll to you. (with source code of course!)
>Hi,
>
>I have sometimes the need to do a batch update on a table buffered table: something in the range of 8.000 records and the underlying table has about 300.000 records. This may take several minutes and I'd like to show some sort of thermometer to the user. But I find no way to do it since I have no clue on how the update process is going. I am using a transaction like this:
>
> BEGIN TRANSACTION
> IF TABLEUPDATE(.T.)
> END TRANSACTION
> ELSE
> ROLLBACK
> TABLEREVERT(.T.)
> ErrorMsg(this.cMsgUpdateFailed + " Table: WageHead")
> SELECT (lnCurSel)
> RETURN .F.
> ENDIF
>
>Any idea how to update the progressbar while I am in the transaction?
>
>José
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