Re: Insert Errors - Specific Fields

[Jean-Luc Peyret <Jean-Luc_Peyret@PEOPLESOFT.COM>]

Hi.

Valid points about displaying fields and checking for empty strings.
But...

Keep in mind that if your table has more fields defined than your insert
statements, then fields not in the insert will be inserted at NULL values.

Ex:  T1 (col1, col2, col3)

insert T1 (col1, col3) values ('col1','col3');     => null value errors on
col2 which is not in insert statements IF col2 is NOT
     NULL
JLuc

FYI - I believe Sybase has the nice habit of indicating problem field names
on this error.