Hello,
I am using SQL Server 2000 as database. When a user updates a record, let's say phone no, and just erases the value already stored, then VB.Net tries to store it as a zero-string. This doesn't work that well and SQL Server throws an error. Do I really have to check every value with if/then/else first to see if it is zero-string and if so convert it it NULL before running the update query?
Thanks,
Marcus
I am using SQL Server 2000 as database. When a user updates a record, let's say phone no, and just erases the value already stored, then VB.Net tries to store it as a zero-string. This doesn't work that well and SQL Server throws an error. Do I really have to check every value with if/then/else first to see if it is zero-string and if so convert it it NULL before running the update query?
Thanks,
Marcus