Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to update progressbar value during tableupdate?
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00050346
Message ID:
00050403
Views:
34
The only way I can think of to do this would be to update the table one record at a time in a loop and update the progress bar's .Value each time. I'm not 100% sure but I beleive once a TABLEUPDATE() of all records for a table buffered table is issued VFP takes total control with no opportunity for interaction with the app until the TABLEUPDATE() is complete.

>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é
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform