getdate in insert request.

Posts   
 
    
lsdev
User
Posts: 4
Joined: 16-Jul-2007
# Posted on: 27-Jul-2007 16:07:56   

Hello, is It possible to generate this request whith LLBLGen ?

INSERT INTO test_tab (Nb1,DateDeCreation)
     VALUES (1000000,getdate())

In LLBLGen documentation, it use DbFunctionCall with SELECT requet unfortunatly I don't found exmple for a INSERT request.

thank you for you help.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 27-Jul-2007 16:21:59   

IMHO, this should be implmented with a default GetDate() value in the database. And if you don't set the corrsponding entityfield before saving the entity, nothing will be inserted for this field, then the field will take its value from the default value assigned to it.

lsdev
User
Posts: 4
Joined: 16-Jul-2007
# Posted on: 30-Jul-2007 17:50:49   

Thanks for your quick answer.