How to fix System.Data.SQLite.SQLiteException: "SQL logic error near "(": syntax error" error?

Question

SQL

Hello!
There is the following code for connecting to the database and executing an sql query:

SQLiteConnection connect = new SQLiteConnection("Data source = accounts.db");
            connect.Open();
            try
            {
                SQLiteCommand command = new SQLiteCommand($"UPDATE users (Name, Surname) SET ('{NameField.Text}','{SurnameField.Text}') WHERE Login = '{LoginField.Text}'", connect);
                command.ExecuteNonQuery();
            }
            finally
            {
                MessageBox.Show($"Изменения сохранены!");
                connect.Close();
            }

It also has the following error:

System.Data.SQLite.SQLiteException: "SQL logic error
near "(": syntax error"

And this error came out on this line:
command.ExecuteNonQuery();
And from all this the question arose:
Where is the error and how to fix it?

Answer 1

Your query syntax is incorrect.
UPDATE is written like this:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;