just add a unique constraint on the things you want to be unique... On Wed, 10 Oct 2001 14:37:09 -0600, Glenn Sullivan <[EMAIL PROTECTED]> wrote: > Greetings, > > I need to check a table to see if an item already exist in the table. > It if does not, then I want to add it. Unfortunately, multiple processes > (Solaris system) can be running at the same time. Sometimes, one process > checks to see if an item exist and it does not. At the same time another > process checks to see if the same item exist and it does not. Then both, > add the item to the table. This is, of course, not what I want. > > I cannot seem to figure out how to do a conditional test to do something > like this. If I could, then the whole operation could fit in one transaction > with locking. > > Any ideas? > > Thanks, > Glenn > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Aasmund Midttun Godal [EMAIL PROTECTED] - http://www.godal.com/ +47 40 45 20 46 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly