SQL translation

Hello all,

I'm attempting to TEST a rollover and get this error message.  Can some translated it for me please?

Select Error: SQLSTATE = 2300

Microsoft OLE DB Provider for SQL Server

Cannot insert the value NULL into column 'appeal_no',table 'impresario.dbo.T_PROMOTION';column does not allow nulls.INSERT fails.

Parents
  • Hi Darrell,

    Good day.

    it means you tried to insert a null value into t_promotion table. because in t_promotion table, field appeal_no is a  (int not null) field, then you got this error message.

    if you open a sql profiler try to catch the sql statement, then you can see what had happened.

    have fun

    Ben

     

     

Reply
  • Hi Darrell,

    Good day.

    it means you tried to insert a null value into t_promotion table. because in t_promotion table, field appeal_no is a  (int not null) field, then you got this error message.

    if you open a sql profiler try to catch the sql statement, then you can see what had happened.

    have fun

    Ben

     

     

Children
No Data