Re: index column Unique or empty

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 t

Re: index column Unique or empty

. Berard, "Life-Cycle Approaches" -- From: "Dave Crozier" <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2008 1:27 PM To: <[EMAIL PROTECTED]> Subject: RE: index column Unique or empty > Ajoy, > Your requirement bre

RE: index column Unique or empty

Remember that database rules regarding uniqueness are there for a reason, but only when the database has been properly designed. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajoy Khaund Sent: 11 November 2008 06:44 To: Profox Subject: in

Re: index column Unique or empty

something like INDEX ON yourfield CANDIDATE FOR !EMPTY(yourfield) ? > I have field which can be empty else it must be unique. Can I create such a > index which will throw an error. > > Ajoy Khaund > > -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org

index column Unique or empty

Hi I have field which can be empty else it must be unique. Can I create such a index which will throw an error. TIA Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on