Try to pass SET NULL OFF before insert.

>When I run this code;
>
>

>oCommand = CREATEOBJECT("ADODB.Command")
>
>cCommandString = "insert into bspotln (docid, boid) values (" +;
>TRANSFORM(nDocId) + "," + TRANSFORM(nNewId) +")"
>
>WITH oCommand
>  .CommandText 			= cCommandString
>  .ActiveConnection 	= This.oConnection
>  .CommandType 			= adCmdText
>ENDWITH
>
>oCommand.Execute
>

>
>I get the error "Field 'xyz' does not accept null values". Is there a way
>to override this or turn it off? I dont want to have to fill in ALL the
>fields to add a record.
>
>Thanks