Hibernate version:1.0.2.0

Hi,

I'm new to this forum and using NH, - and I can say, that I am highly impressed by the job, NH does to the DB.

My problem:
I do not want to delete a record physically, so I intent to implement a column named recordstatus to any table, where 0 means "deleted" an 1 means "activ" record.

How I can say NH at a central point, not to work with records with an recordstatus equal to 0?

I'd like to use the powerfull ability of "lazy loading" collections furthermore. On the other hand, NH should use the WHERE-condition in the automatically created SQL-Statement.

I tried the where="..."-condition, which can(?) be used in the SET section of a collection. No success. I read about NH3.x for java, where this works fine?!?!?

Does someone has a hint for me?
Thank you and best regards
Markus