General information
Category:
Forms & Form designer
Title:
Handling Null values on form and saving it in SQL server
Environment versions
Network:
Windows 2008 Server
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
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