>>It's FPD 2.6, no optimistic locking only FLOCK() & RLOCK()

I'm not sure I understand your answer.

1) Are you sure you need FLOCK()

2) You can optimistically or pessimistically lock with explicit locks (FLOCK() and RLOCK()) -- that's not the issue.

3) I asked whether you were using READ NOLOCK. If you are not you probably should be <s>.

I should also probably have asked whether you read to memvars or directly to the table -- but you can still handle this even if you read directly to the table.

So, okay, let's take this a little slower, run your multi-user practices by me and I'll try to explain how my suggestion would apply <s>.

>L<