var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
if i save a date value within a smalldatetime field, then later want to edit the record and set the smalldatetime field to nothing, how can i do this. I've tried populating the field with Null, and anything else, without success. Any suggestions?
I just simulated your situation.
I created a table with a smalldatetime field and then added a date and then set it as null using the following statement
SET MyDate = NULL
If this does not work check if you Allow Nulls on that field
Double J IT Solutions
VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors