Error: Cannot insert NULL into rowguid

[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

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


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

Of course, SQL Server creates and populates the rowguid column; 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.

 

[culshaja]

Issue an ALTER statement on the table that you are inserting to to set a DEFAULT of NewID() on the column that requires the GUID, either that or use NewID() in the position of the sql statement that matches the GUID column.

NewID() is the SQL Server function that generates a new GUID.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305