You are not logged in.
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)