add new row in sqlite

[GhostXoP]

How would i add a new row using dbExec? Im in the direction of INSERT INTO -table- but would i then just put (value col 1) (value col 2) etc?

dbExec(ServerDataBase, "INSERT INTO ClientData (username, password, data) VALUES ("..Username..","..Password..","..Data..")" 

?

[Renkon]

For strings you gotta use: 'text'

[GhostXoP]

username TEXT, password TEXT etc? What if the table is already made?

[Castillo]

There's an example on the wiki about inserting with SQlite:

dbExec( connection, "INSERT INTO table_name VALUES (?,?,?)", "aaa", "bbb", 10 ) 

[GhostXoP]

That shows for setting data, what about updating data?

[Castillo]

There's also an example for updating data:

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

[GhostXoP]

Hows this

dbExec(ServerDataBase, "UPDATE ClientData SET data ="..Data.." WHERE username=".."'"..Username.."'".." AND password=".."'"..password.."'")