import sqlite3 conn = sqlite3.connect("report.sqb") cursor = conn.cursor() sql = "SELECT * FROM report WHERE type LIKE 'C%'" cursor.execute(sql) data = cursor.fetchall() for row in data: ms, cs, rg = row[0].split(';') fieldid = row[0] print (f"row: {row}") sql2 = f"UPDATE report SET rg='{rg}', ms='{ms}', cs='{cs}' WHERE fieldid = '{fieldid}'" print (f"\rsql2: {sql2}") cursor.execute(sql2) conn.commit() cursor.close() conn.close()
(May-08-2021, 04:15 PM)Larz60+ Wrote: ibreeden: you suggested the same code that I posted in post 2