Hello - I am using VB6 with a SQL

[JohnBates]

Hello -
I am using VB6 with a SQL Server 7 database.

When I attempt to ADD a row to the recordset (ex: rsLoadId.Update)...get this error:

btnOpenSpur_Click: 01000: [ODBC SQL Server Driver] The statement has been terminated.
23000: [SQL Server] Cannot insert the value NULL into column 'rowguid', table 'frigdare.dbo.LoadId';
column does not allow nulls. INSERT fails.
Error: 40002=> '01000:[SQL Server] The statement has been terminated' Occurred at line : 100

As you know, the rowguid is created and populated by SQL Server to make certain that every row has a Unique identifier.....



rsLoadId.AddNew
.
. populate the columns...
.
.


and Line 100 is: rsLoadId.Update (the Error occurs here)


Of course, I do not move anything into the rowguid column,
so I am puzzled by this error...

Does anyone know why this would occur ??

Thanks for any ideas.