I have an SQL application that is a big problem.

In foxpro when you append blank, (on an SQL remote view) it does not put NULL in the fields that allow null.

So if the SQL program (Dot Net VB program) expects null then they will NOT be there unless I store null to each field


Is there a way to make VFP append blank put null in the fields that are defines as allow null?

Even on a VFP table (DBF in a DBC) when I append blank, it does NOT put Null in the fields even though they are defined as allow null. Character fields is puts blank. On dates and numbers that is a big problem too

VFP has settings for everything so I am sure there is some setting to define what is inserted, but I simply can not find outr where to change that.