UPDATE SQLITE TABLE - Copy a fields content to another field.

[andrewarles]

The output is working correctly and shows the sql2 print being populated with the correct string.

It's the test.sqb file that is not updating correctly.

[andrewarles]

Created a new sqb from scratch and it's now working, so there appeared to be a problem with the db.

Thanks everyone for your help.

[Larz60+]

ibreeden: you suggested the same code that I posted in post 2.
andrewarles: I wanted you to post the results of my post 2, not just commet on them.

Also, as ibreeden pointed out, we need to see the structure of the table you are trying to update.
and take heed to his advise on WHERE clause.

[andrewarles]

Here's the code that works ok:

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()

[ibreeden]

ibreeden: you suggested the same code that I posted in post 2

@Larz60+ Yes indeed, your code seemed good to me. I only added a "where" clause.