Bryan White wrote: > > I have a table with a unique index. When I go to insert a new value into > the table my code does not know if the record is already there. To me there > are two choices: > > 1) Do a select for the record and insert only if not found. > > 2) Do a blind insert and relay on the unique index to fail the insert if > there is a duplicate. 3) Use a sequence to generate unique indicies for you? -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://cupid.suninternet.com/~kleptog/