confusing error
-
I have a simple update statement on a table on MSSQL7:
UPDATE MERENI SET MERENI.Hod=-0.5, Kval=' ', Zmena=1 WHERE Ident = 'SLV4485_MI__'
This runs O.K. When I change it to modify other record:
UPDATE MERENI SET MERENI.Hod=-0.5, Kval=' ', Zmena=1 WHERE Ident = 'SLV4485_MQ__'
It ends with:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.:confused: Pavel Sonork 100.15206
-
I have a simple update statement on a table on MSSQL7:
UPDATE MERENI SET MERENI.Hod=-0.5, Kval=' ', Zmena=1 WHERE Ident = 'SLV4485_MI__'
This runs O.K. When I change it to modify other record:
UPDATE MERENI SET MERENI.Hod=-0.5, Kval=' ', Zmena=1 WHERE Ident = 'SLV4485_MQ__'
It ends with:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.:confused: Pavel Sonork 100.15206
Solved. I forgot about a trigger. :-O Pavel Sonork 100.15206