Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Clipper Visual-Objects > Re: SQL record ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 9 Topic 11548 of 11703
Post > Topic >>

Re: SQL record locking

by "richard.townsendrose" <richard.townsendrose@[EMAIL PROTECTED] > Jul 21, 2008 at 08:02 PM

Rob

I have been thru this saga many times......

What i do is table locks. and i forget all about checking if the
record has changed. mostly one is writing new records.

locking a table is much faster .... and when there is a crash, there
are no held open record locks - apart from the userlog table which
doesn't matter - indeed one can use that to tell who is and isn't
logged on as it has datetimesin and datetimesout fields, and mode out
(normal, controlled crash, or bang out)

richard
 




 9 Posts in Topic:
SQL record locking
Rob van Erk <erk.v@[EM  2008-07-20 12:41:19 
Re: SQL record locking
"Geoff Schaller"  2008-07-20 22:48:21 
Re: SQL record locking
Robert van der Hulst <  2008-07-21 10:35:29 
Re: SQL record locking
Rob van Erk <erk.v@[EM  2008-07-21 12:05:00 
Re: SQL record locking
"richard.townsendros  2008-07-21 20:02:18 
Re: SQL record locking
"Geoff Schaller"  2008-07-22 03:51:29 
Re: SQL record locking
DPLuigi <dpluigi@[EMAI  2008-07-22 00:28:40 
Re: SQL record locking
Rob van Erk <erk.v@[EM  2008-07-22 10:56:31 
Re: SQL record locking
edgsun <edgsun@[EMAIL   2008-07-23 07:28:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Oct 10 21:14:32 CDT 2008.