Post reply

Error Message

  • June 30, 2006 at 12:18 pm

    #68325

    I received the following:

    cannot insert a non-null value into a timestamp column.  Use INSERT with column list or with a default of NULL for the timestamp column.

    I am trying to append to a table that every field in it allows nulls.

     

    Any and all assistance will be greatly appreciated.

     

  • June 30, 2006 at 12:33 pm

    #647058

    Columns of datatype timestamp are maintained by the system and shouldn't be in your INSERT column list. The error is telling you that you're trying to insert an explicit value into a timestamp column, which you can't do because it is a system maintained value.

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply