Can't remember if this problem is mention before:
I've a mysql-table with the following fields:
`created_on` timestamp NOT NULL default '1980-01-01 00:00:00',`updated_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
If I make directly an update from Tersus and don't fill these fields they are set to "NULL", (there is no difference if field mandatory is false or true) see log:
Executing statement: 'UPDATE tprojectbwkmut SET VerwOpbrMW=? , BegrMutKst=? , TotVerwKst=? , Opsl=? , opmerk=? , modi_by=? , created_on=? , updated_on=? WHERE comp=? AND Proj=? AND Strc=? AND Kstnnr=? AND Bewk=?' values: 0,0,0,25,'ZXZXZXxxxx','jvdg',null,null,'110','070D02','B','3','3001'
After this update both fields have the current systemtime. I think this is not correct, it must be possible the fields are not updated at all.
Jan Pieter
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign