Oracle nullable datetimes

Posts   
 
    
happyfirst
User
Posts: 215
Joined: 28-Nov-2008
# Posted on: 08-Jan-2009 22:16:07   

2.6 - 11g - SelfServ

I have two tables. One of them , all the datetime fields can be null and the generated entity has those properties correctly as nullable datetimes (datetime?) and it works as expected.

The other table also has datetime fields that can be null, but the very first datetime field in that table does not allow null. And ALL of the properties in that generated entity are datetime. Only the first datetime should be datetime. All the others should be 'datetime?' ?When I retrieve a collection of this entity, some of the datetimes that the db has as null are instead 1/1/1.

Or am I doing something wrong?

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 08-Jan-2009 22:19:15   

Could you attach a SQL script to create the tables, and your LLBLGen project please, to allow us to investigate further...

Thanks

Matt

happyfirst
User
Posts: 215
Joined: 28-Nov-2008
# Posted on: 08-Jan-2009 22:37:26   

thanks

I've posted the files in the secure section under a new thread.