Personally, I dont think so. This isnt "exceptional", so it should raise an
exception. Remember, "Exceptions are exceptional". This is, however, silly. I
WOULD expect it to use the last value. Being in the western hemisphere, by
default my brain works from left to right. Evaluating the field/value pairs,
this is the behavior I would expect.

Jason

Mitchell Peek wrote:

> Found some buggy code that dynamically produced this statement
>
> Insert into COSTTYPE
> (ID,COSTTYPE,ALLOWDELTA,ALLOWDELTA)
> Values
> (1,'TEST','Y','N')
>
> My tests show that the latter of the two is the value actually used. is
> this always the case? Shouldn't this produce some sort of error?
>
> Forgive me in advance if this topic has been covered.
>
> Regards,
> Mitchell Peek
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.