Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Occasionally hanging on a table with buffering
Message
From
18/01/2008 16:54:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Occasionally hanging on a table with buffering
Miscellaneous
Thread ID:
01283131
Message ID:
01283131
Views:
56
I've been having problems from time to time with one form that uses buffering. The problem, which occurs very sporadically, is that sometimes, when one user is on the form, all other users who start up the form get stuck with the hour glass.

Once the form has this problem, all of us get hung .... but I have been unable to cause it to happen in any way.

The form is fairly simple, and allows for adding/editing some simple records. Buffering is turned on (see PROCs below) if either adding a new record or when an existing record is selected to edit. Buffering is turned off later, allowing the table to update or reverting. There is no use of LOCK, RLOCK, or UNLOCK,

Curiously, this seems to work for extended periods of time (usually a week or two between reported problems).

Any suggestions?

Thanks
Procedure StartBuffering(lcAlias)
	CursorSetProp("Buffering",5,lcAlias)
Endproc


Procedure PostBuffering(lcAlias)
	Tableupdate(2, .T., lcAlias)
	CursorSetProp("Buffering",1,lcAlias)
Endproc


Procedure NoPostBuffering(lcAlias)
	Tablerevert(.T.,lcAlias)
	CursorSetProp("Buffering",1,lcAlias)
Endproc
Jim Nelson
Newbury Park, CA
Next
Reply
Map
View

Click here to load this message in the networking platform