General information
Title:
TABLEUPDATE & Remote View
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?
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only