I've created a table on SQL Server with several fields, specifying them not to allow null values. I have also created a basic form operating on a remote view of this table. My basic problem is when I add a new record to the view, fill in some of the fields and issue a TABLEUPDATE(), I get this error message...

"...Cannot insert the value NULL into column 'cstatus'...column does not allow nulls. INSERT fails."

So, how can I tell VFP not to send empty text fields back as NULL? I've tried doing the following even though I've never heard of doing this...

DBSetProp('V_WORKLOG.cstatus', 'Field', 'DataType', "C(1) NOT NULL")

but this does not help. So, do I have to cycle thru the empty fields and load them with at least a blank? Surely there is a better way to handle this. Funny, I've not seen any discussion of this in any C/S book or article.

Thanks for any help...

Del