I want to have an update statement like:
update tblMydate set fieldx=fieldx+1 where code=12
But then for a boolean value:
So, if the current boolean value is true, I want to set it to false and vice versa, something like
update tblMydate set booleanx=not booleanx where code=12
How can I achieve this?
edit: killed erroneous h2 — mod