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:56:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/01/2008 16:54:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01283131
Message ID:
01283132
Views:
16
>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
>
Why you're turning off buffering. I think leaving it on would cure your problem.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform