如何为双字段设置空值 [英] How to set null value for double field

问题描述

你好，
.我有一张带有2个双字段的表格.值显示在标签中.从数据库中检索值时，我可以检查天气是否为空或为空.但是，在将值存储到数据库时，如果将值设置为Null，则它将在数据库中存储1；如果将值设置为空，则它将0存储到数据库中.
由于该字段可以具有-ve值，因此+ ve值也可以为0.但默认情况下，它应该为null.
现在任何人都可以.帮助我解决此问题，因为我无法将null值存储到access中的double类型字段中.
提前谢谢.
--regards
--harshada

Hello,
 I am having a table with 2 double fields. and the value is shown in label. While retriveing the value from database i can check weather it is null or empty. But while storing the value to the database, if i set the value to Null it is storing 1 in database, and if i set the value to Empty, it stores 0 to the database.
As the field can have -ve values, +ve values as well as it can be 0 too. But by default it should be null.
Now can anyone pls. help me for solving this problem, as i m not able to store null value to the double type field in access. 
Thanks in advance.
--regards
--harshada

推荐答案

您可能想尝试

这篇关于如何为双字段设置空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！