Re: validate the uniqueness of data first before inserting
Re: validate the uniqueness of data first before inserting
- Subject: Re: validate the uniqueness of data first before inserting
- From: Patrick Robinson <email@hidden>
- Date: Wed, 16 Jun 2004 08:43:24 -0400
On Jun 16, 2004, at 6:09 AM, Ashley Aitken wrote:
On 16/06/2004, at 5:32 PM, Goh Keng Boon wrote:
I got this field called customer_code which is keyin by user manually
and it need to be unique. How can it check if it is unique first
before inserting the whole record into database?
Try and fetch an object/record with the same value for customer_code
...
The problem with this approach is that someone else could insert a row
with your customer_code value after you check for it, but before your
insert fires.
This is a case where it's nice when you can depend on the database to
enforce constraints... you can catch any resulting exceptions, and
handle appropriately.
--
Patrick Robinson
AHNR Info Technology, Virginia Tech
email@hidden
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.