I'm using remote views in my application to access a SQL database on a remote server.
These remote views are updatable. Once in a while, for some reason a fields nbalowed
N(12,2) contains value -.00 instead of 0.00 or .00, so when system retrieve data using
REQUERY() on remote view,update with 100.00 & apply TABLEUPDATE(), internally VFP send

sp_executesql N'UPDATE Tenant SET nbalowed=@P1 WHERE cid=@P2 AND nbalowed=@P3', N'@P1 numeric(18,2),@P2 char(6),@P3 numeric(18,2)', 100, ' 179L', 0

which fails & generate update conflict ( I checked no one using system except me)

I still haven't figured out values get changed to -.00.

When I Applied

UPDATE TENANT SET nbalowed = 0.00 where CONVERT(char(20),nbalowed) = "-0.00"

and execute tableupdate, system not reporting error.

Can anyone give me a hint what's happening here & how to solve it?