Update command in MSQL

[Former Member]

Hi Gurus

I want to update one row with the m-sql command, but when run the command getting with the error as , can anyone tell me what is the exact command then

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 's903'.

UPDATE WG3.S903

SET NETWR = 0.00 WHERE

VGBEL = 0080159749

AND

VGPOS = 000010

AND**

NETWR = 200.00

regards

[clas_hortien · Accepted solution]

Hello,

if this is a SAP system, the schema identifier has to be lowercase like:

update wg3.S903 set ...

Or you can do a

setuser 'wg3'

go

update S903 set ...

Do you really want to update some rows manually ? Why don't you use the SAp system for this ?

Regards

Clas

[Former Member · Accepted solution]

hi,

This error will come if the table named S903 does not exist.

supply the right name and then try.

please close the thread if its already answered

Regards

Deepak

[Former Member]

Hi

Thanks Thread close solve the problem

regards

Piroz