All dba firebird,

I change/edit my table field 'mytime' type timestamp from without 'deafult now' to be ' default 'now'' with ibexpert.
Impact :
My program application error when edit data :
' Record not found or change by another user'

Solution :
- Drop field mytime (alter table mytable drop mytime)
- add field mytime (alter table mytable add mytime timestamp default 'now')

Its working... No error again.

Why ?


Thanks
Regards
Allies
Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!