Re: ANSI vs. Non-ANSI

Calvin Ng (calvinng@technet.sg) wrote: : >stuff snipped< : : Point taken. Question: Shouldn't then that Online has some form of timer : that will release a lock after some time, and return a error message to : the process that place the lock?? : BTW, isn't it a MUST to log out of your terminal when you are going for : lunch, I mean security and all that :-) No, from a designers viewpoint st least SOME users are blithering idiots who can be counted upon to use their ignorance to find the weakest point in your design and wreak the most havoc thereby. : Seriously, has anyone written an application that will exit gracefully after : being inactive for a certain period of time?? Yes, we do this as a matter of course AS LONG AS the use has nothing in process (no modification or new entry in process, etc). We put the timeout period in the user settings file so that it may be user specific, but there is a global default. A point that wasn't specifically brought out in this thread, but which we consider to be gospel, is that the duration of locks must not be dependent upon the whims of the users (a user should not be able to leave the customer master entry locked while he/she goes to lunch). This means we use optimistic locking and other schemes to accomplish updates and other transactions. Regards, Larry Jones @ --------------------------------------------------------------------- Caelus, Inc. ! Complete, Integrated Solutions! "I assume complete Spokane, WA ! for Manufacturers World-Wide ! responsibility for what (509) 455-8566 ! (HP-UX, OSF-1, AIX) ! I said (what did I say?)"