Datetime field with getdate() not auto generating

Hi,

Does anyone know why I have a Datetime field set to getdate() by default in an SQL Server 2008 R2 database but it's inserting NULL. As far as I know thats all I need to do???

I think I have a ghost in the machine!

Cheers,

Mike.

Re: Datetime field with getdate() not auto generating

it should work... how r u setting default value?

try this

ALTER TABLE TableName
ADD DEFAULT GETDATE() FOR ColumnName
go

hope this helps...

Re: Datetime field with getdate() not auto generating

Thanks kedarrkulkarni,

But i'm doing all this from inside VWD and my hosting company has a GUI for all of this too.

I must have built 500 databases in my life and never had to CRUD on via SQL.

Sorry,

Mike.

Re: Datetime field with getdate() not auto generating

how are you inserting data in table row? r u seding the dataset updates from dataadater?

u might have datetime field included in there....

may be posting the code would help

Re: Datetime field with getdate() not auto generating

Its a WCF and Im now inserting the date with the other fields with the following code. I thought I could simply make the CommuniqueDate field by default set its self to the server date with getdate() when a new record is inserted but it doesnt seem to want to.

public bool putCommunique(string communiqueIMEI, string communiqueType)
{
    Communique communique = new Communique
    {
        CommuniqueIMEI = communiqueIMEI,
        CommuniqueType = communiqueType,
        CommuniqueDate = DateTime.Now
    };

    _db.Communiques.AddObject(communique);
    _db.SaveChanges();

    return true;
}

Cheers,

Mike.

Re: Datetime field with getdate() not auto generating

Hi bojangles,

Have you tried to test that whether DateTime.Now has passed value to CommuniqueDate or not? You could use try...catch to catch that error.

ObjectContext.AddObject Method :http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.addobject.aspx

Thanks.

Re: Datetime field with getdate() not auto generating

Thanks Chen Yu,

Ive had a look through some Microsoft auto generated code, e.g.. the code generated for membership and the aspnet.mdf when you create a new MVC site and it looks like MS dont rely on SQL Server adding the date time automatically. So I will do it this way from now on.

Cheers,

Mike.