Sponsors
Search
Link to our site
Learning Resources
From Matt Olson via Midrange.com Consider using sequences instead and remove the logic to see if a contact already exists (aka checking to make SURE it is unique. It will always be unique unless you have rogue programs out there not using the sequence object) Create statement: CREATE SEQUENCE seq_contact MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 10 Usage: INSERT INTO Contact (P_Id,FirstName,LastName) VALUES (seq_contact.nextval,'Lars','Monsen')
[report a broken link by clicking here]
