UPDATE statement not functioning

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

UPDATE statement not functioning

Author

Topic

tariq2
Posting Yak Master

125 Posts

Posted - 2012-02-07 : 06:59:08

Usually I have no issues with basic UPDATE statements.
However below doesnt work, with 58407,'58407',58407.00?

The datatype is MONEY, is that the issue?

update F_AP
set Current = 58407
where DocNumber = '11000274' and DocCompany = '14005'
and PeriodKey = 108

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-02-07 : 07:09:05

Does it work with any value other than 58407 in any of its forms? When I tried to parse it, it does not parse not because of the 58407, but because Current is a keyword. So see if this works:

update F_AP
set [Current] = 58407
where DocNumber = '11000274' and DocCompany = '14005'
and PeriodKey = 108

tariq2
Posting Yak Master

125 Posts

Posted - 2012-02-07 : 08:11:39

Yes,thats exactly why. Thank You :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources