Do you have some kind of uniqueness constraint (not necessarily Identity)? Sounds like you are counting on SQL Server to auto-populate this column but have not defined a way for SQL Server to do so.
>While attempting to use a CursorAdapter to talk to a MS SQL Server 2000 backend, I am getting a 1526 error that says "CommunityId column does not accept null values." It's a BIGINT data type on the back end and I have it set to zero in the record that's getting updated. And actually, I have that field now set to not update via the Auto-Updates tab in the CA builder, yet I still get this message.
>
>I needed to add six records in a VFP table to the SQL table. I was able to add the first record with no problems, but now I get this error. I'm not sure why it would work once and then wouldn't work after that.
>
>Any thoughts would be appreciated.
>
>Russell Campbell
Mark McCasland
Midlothian, TX USA