469,626 Members | 1,046 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

Restrict selecting from a table

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 :)

Oct 5 '05 #1
1 1294
>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
Oct 5 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Terabyte | last post: by
3 posts views Thread by razheev | last post: by
4 posts views Thread by Neil Coleclough | last post: by
21 posts views Thread by Niu Xiao | last post: by
5 posts views Thread by Arun Srinivasan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.