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