Bill,

have you checked the SQL database attributes?.

Sometimes, when you create a table in SQL Server, one of the column's propperties or validation rule is a not .NULL. insertion or perhaps a valid length of the data (>0).

Try to send a sql insert command with all the fields filled with data.

This error does not appear in Foxpro Tables because when you insert a new record, it assumes the field type and accepts empty fields.