Hi,

i need use update statement in MSSQL Server 2005. For example UPDATE Table set column = 2
From Metadata i dropped table as tMSSQLRow and wrote that SQL but i get errors where is mentioned that table columns.

Error sounds like that

Syntax error on token "Table", ; expected
set cannot be resolved to a type
Column1 cannot be resolved or is not a field
Column2 cannot be resolved or is not a field
......
UPDATE cannot be resolved to a variable

Interesting is that when i use SQL Builder and run that SQL it works fine(i checked in database). Where can be a problem?

Edit: problem resolved

Last edited by ataris (2011-05-03 11:40:29)