>Larry,
> thanks for the reply. I was hoping there was some other way. Having a timer fire off after about 2-3 seconds of inactivity is a good idea but locking the record seems extreme. Some of my customers are still running Novell and it has problems releasing record locks sometimes so I would rather not go that way.
>Thanks for the input.
John,
I worked with Novell for years and never had a problem with it not releasing locks. We had all kinds of problems with Lan Manager and Banyan Vines, but not Novell.
IAC, if you don't want the to locking, then you have to use SET REFRESH. If thatr is slow, perhaps it isn't the SET REFRESH itself but the filter being applied. Depending on how you're using them could cause performance problems. For example, filters used with grids run like c@#p. In this case, I would recommend using parameterized views instead. If the appropriate indexes exist, these are highly optimizable and having a timer go off every few seconds to requery the view should work great.
Good luck!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao