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

Reply via email to