alter and Store recordset in sqlite

Databases
1

Is it possible to alter a recordset after recieving it from sqlite.db and insert it into the same database as new line into a table?
I couldn’t find the SQL commands. (alteration in XOJO)

2

for SQL you use the UPDATE command

"SQL=“UPDATE mytable SET myfield=3 WHERE somecondition”

3

That is clear, but I asked if there is a command, which says
rs.Field(“myfield”)=“XYZ”
INSERT INTO mytable RS
???

4

CREATE TEMPORARY TABLE tmp AS SELECT * FROM src WHERE ...; UPDATE tmp SET id = NULL; INSERT INTO src SELECT * FROM tmp; DROP TABLE tmp;

5

look at the methods rs.edit , then rs.update

6

He does not want to UPDATE he want top “COPY” or “DUPLICATE” a row :wink:

7

Thanks Sascha - Didn’t try it yet, ---- but reading it, it will work :wink: