Hi

We have a typical requirement. We use VFP and SQL Server 2008 r2.

Say we have a sql table with 10 fields (Numeric, Char, Bit, Varchar(max) etc.) and they are null allowed.

Our requirement is that how do we manage null. In our frontend interface form
we will use textbox to accept the information. Each textbox will be initialise
with either Zero, Space, .t./.f.

The requirement is that if the user does not have a information for a particular
attribute (field) then it should be saved as null in sql. But if he has the value
then it should save that value in sql. Even zero can be a valid value.

In all other case we should be able to save the record as null.

Regards
Upendra Nayak