Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
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.fetch...
 andrewarles General Coding Help 14 4,400 May-08-2021, 04:43 PM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
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.
 andrewarles General Coding Help 14 4,400 May-08-2021, 01:30 PM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
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 General Coding Help 14 4,400 May-08-2021, 11:57 AM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
Thanks, but that only updates the first row. The remaining rows are not updated.
 andrewarles General Coding Help 14 4,400 May-08-2021, 10:50 AM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
There is no unique key, there is a primary key on field1. There are 15 columns made up of varchar's and integer's.
 andrewarles General Coding Help 14 4,400 May-08-2021, 09:40 AM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
Ok, so what would the WHERE clause be in order to update the row that the cursor's on?
 andrewarles General Coding Help 14 4,400 May-08-2021, 09:02 AM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: RE: UPDATE SQLITE TABLE - Copy a fields content to...
Thanks for the reply. The variable in being passed to the sqlstmt, and the sqlstmt is being printed correctly with its corresponding value, but when updating the db, all rows are still being updated ...
 andrewarles General Coding Help 14 4,400 May-08-2021, 07:36 AM
    Thread: UPDATE SQLITE TABLE - Copy a fields content to another field.
Post: UPDATE SQLITE TABLE - Copy a fields content to ano...
Hi, I am trying to go through filtered records and copy the contents, line by line, of field1 to field2. Why is the field2 being filled with the same value and not it's corresponding field1 value? T...
 andrewarles General Coding Help 14 4,400 May-07-2021, 04:02 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020