Hi.
Suppose I got a table with data like this:
id (primary key) data(string)
1 test1
2 test2
3 hello
4 world
then I exec a SQL like this UPDATE this_table SET data='abc' WHERE id > 2.
After that, my table should look like this:
id (primary key) data(string)
1 test1
2 test2
3 abc
4 abc
OK. We all know that row 3 and row 4 was updated by my SQL. But how should
my program know that?
The only way I know to achieve this is write several SQL strings like this:
SELECT id FROM this_table WHERE id > 2;
foreach (_id in selection)
UPDATE this_table SET data='abc' WHERE id=_id
It's an unefficient way as we all know. So I would want to know is there a
better way to do this?
Thank you.
Regrads.
Wu
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
