Are you trying to insert NULL into the field?
>
>Our company is remotely sending data down from MSSQL to a foxpro table (vfp 8 sp1) at a users site (using ODBC I believe).
>
>They have been getting a problem recently (the part few weeks), where one of the fields in the foxpro table is throwing an error of ......
>
>'“CUSTOMER” table is failing because of the field “PAQUINNUMB” being NULL".
>
>The Paquinnumb field is indeep set NOT to accept NULLS in the Foxpro table.
>
>So, any ideas why this is occuring now?
>
>Thanks!
--sb--