General information
Title:
Cannot Insert Value NULL IN Column
To all,
Back again! From one issue to another but you're help has moved me forward.
I created a Table in SQL Server 2012 with a character field set to "Not NULL". NULLs have been giving me issues in searching. I get and error: 'Cannot Insert Value NULL IN Column field cSteinLoc. Column does not allow NULLs.' I checked to see what SET NULL is in VFP and it is OFF. It seems to be trying to Insert a NULL value into fields. Even when I use a default of ' ', it still inserts the NULL???
Does anyone know why this is happening and how I can prevent VFP from placing NULLs in empty fields when creating a new record?
Thanks,
Bill
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only