Re: Insert Problem

In article <1993Sep6.125832.27915@lmpsbbs.comm.mot.com> ramesh@miel_020.miel.mot.com (Ramesh Pathak) writes: } } I have a cloumn in a table which is defined to be unique but Nulls } allowed. } } And when I try to insert a null value in the same columns, informix online } returns me with an error no. 239! } } What could be the problem? Can I not have a filed unique but allowing } nulls? } A -239 error is a duplicate record error. Apparently you already have a record out there with a NULL in the index column. NULL is a value and you can only store one of them. DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.15 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com