Re: Lock Tables Question

[David T. Ashley]

On 6/4/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote:

David T. Ashley wrote:

LOCK TABLE thistable, thattable, theothertable,
goshthislistcangetlongtable;
Do whatever is needed;
UNLOCK TABLES;

You could use a string lock for this.

Thanks for the suggestion.  It looks logically correct.

I'd like to stay away from a string lock if possible because other database
users could interfere with it (it is server global, and not tied to the
database).

My original question is still of interest to me ...

Thanks.