now i know why. i've tried recreating that part to a new module (because of numerous procedures and items in the original module, it sorts things out) and look at what I've got. it's FRM-40743: This operation with no base table requires the ON LOCK triggers. I've tried looking for it on the web but i only got a handful of sites, most of them with languages i can't understand. does anybody here have any ideas how can I edit, even just a column? it's in my specs that the date part should be updateable and queirable. thanks.