You have to provide values for all fields that don't accept nulls.

>Giving the following:
>
>

>loConnection=CREATEOBJECT('ADODB.Connection')
>loConnection.Open("Provider=VFPOLEDB.1;Data Source=d:\;Mode=ReadWrite;Password='';Collating Sequence=MACHINE")
>
>loRecordSet=CREATEOBJECT('ADODB.RecordSet')
>loRecordSet.Open('INSERT INTO EVENT (Title) VALUES ("TEST")',loConnection,1)
>

>
>How would someone avoid the message about a field which cannot be null?