working with sql inserting type double, string, int - How to detect unasigned value.
Posted on 2011-04-24
i am try to work with data type
double, int, enum, string in vb.net and create a function to insert/select from mysql
i have issue when to create this function i have no way to know if the value should be insert to sql or not because i dont know if it unassigned or or assigned.
the idea is that if i know the value is unassigned then i will not generate TSQL to insert into SQL and so database will not insert incorrect value such as 0 or "".
On the other hand, when pull the data from SQL i need to know that these value is not assigned so i can display on application as not available... instead of showing 0 or something that has incorrect meaning...