On Tue, Nov 11, 2008 at 7:40 AM, Ajoy Khaund <[EMAIL PROTECTED]> wrote: > Dave Thanks and also to Maurice. > > This field is not a very important field. In a employee table permanent > workers have a Provident Fund Number which the temporary guys don't have. > Now I have to have check when saving the record to confirm the number does > not exist. > > Where would you put a check normally. ----------------------------------
I would validate that # before I did the row insert. Is there a high velocity on inserts to this table? If so create a trigger for insert to gen it at insert. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.