Restrict selecting from a table

[hristov.milen]

Hi,
Is there a way to restrict selecting from a table..

I have problem with one check,

I have select and after this insert based on the select. If it happen
in one time .. I can insert incorrect information. If I do lock table
SOMETABLE read; it still select and return results normaly. I'm open
for suggestions :)

P.S. Excuse my bad english :)

[Gordon Burditt]

>Is there a way to restrict selecting from a table..

I have problem with one check,
Please state the problem.
I have select and after this insert based on the select. If it happen
in one time ..
You mean there's a problem if something changes between the select
and the insert?
I can insert incorrect information. If I do lock table
SOMETABLE read; it still select and return results normaly. I'm open
for suggestions :)

If using LOCK TABLE works, why not use it? That's what it's for.
It would appear, though, that you need lock table sometable write,
though, since you're inserting.

Gordon L. Burditt