>Updata mytable set myfield=somevalue where PKfield=someothervalue >if _tally=0 && No such record, so I must create a new > insert into mytable (PKfield,myfield) values (someothervalue,somevalue) >endifHey, what happened with the unexpected behavior of _tally in the command window, when an intellisense script would do some internal SQL and thus change the value of _tally before you had a chance to see the previous value? I don't have that problem, because I check on _tally in the debugger or explicitly in code. Just crossed my mind, and since I haven't heard about this for years - what's the status of that now?