Hi Igor, Saturday, September 6, 2008, 8:27:01 AM, you wrote:
IT> Neville Franks <[EMAIL PROTECTED]> wrote: >> I need to update a column in a set of rows in a table. For each row I >> need to extract the columns value, change it and update the row. >> >> My question is, is it valid to perform an SQL UPDATE inside a >> sqlite3_step() loop. IT> Yes. Thanks. >> Finally is there a better way to accomplish. IT> What is the nature of the change you need to perform? At present the clm data is a list of one or more numeric id's separated by either a space or comma. I need to update this so the id's are always comma separated. -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

