After I make the SPT Result Sets updatable, I receive a update fail msg when I update the data when the current data same as old data.

eg :

I make unit field as updatable field. if I change the data eg. 'pcs' to 'pcs', means data are same, then issue TABLEUPDATE(),and I would receive a update fail msg.

If I issue :

?SQLExec(lconn,"Update table1 SET unit = 'pcs' where ...")

Then is ok.

Why?

TIA.