Updating sql row

[GhostXoP]

This

dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue ) 

is still confusing to me. Where would i specify which row?

And for creating tables, wouldn't i do

dbExec( ServerDataBase, "CREATE TABLE IF NOT EXISTS ClientData (username TEXT, data TEXT)") 

[Castillo]

You don't specify the row, you can use the WHERE clause to know which to update, like this:

dbExec( connection, "UPDATE ?? SET ??=? WHERE ??=?", "users", "money", 5000, "name", "Test" ) 

And yes, that query should create a table.

[GhostXoP]

Thank you