I need to send an update string to a record and if the field is blank, it should write NULL to the db. I has datetime fields and int fields and everytime I update the sql it will put 00:00 for my datetime and 0 for my int. I do not have the whole update string with me, but this is the layout i use:
Update Communications set Dispatched = '" + txtdispatched.text + "' where Item = '" + txtitem.text + "'"
Any help would be greatly appreciated. Thanks in advance.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
There is an easy way, in .NET, to centralize the treatment of all unexpected errors.
First of all, instead of launching the application directly in a Form, you need first to write a Sub called Main, in a module. Then, set the Startup Object to th…