Say I have a UDF called AddOne in a statement like this: update table1 set field1 = AddOne(field1)
and say the table table1 has some million rows. Now I want to test this statement to test the UDF but I want to do this for only one row. How do I do this? limit 1 only applies to data producing statements. Adding a where clause, say where rowid = 1 is a bit tricky (all this has to be done in code) and there may not be a rowid of 1 and I can't do a sqlite3_step as that would run for all the rows. There is no such problem with select statements as I can just run one sqlite3_step and just fetch no data and do a sqlite3_reset. Any suggestions? RBS _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
