I figured it out. I needed to place a fetch statement after the execution statement. That is, right after the exec statement, i needed to write:
curs=fetch(curs)
That problem is solved.
Now, I would like to update the content of a specific cell in a table in the database. I tried using:
colnames={'Password'};
exdata='NewPassword';
fileSelected='BobSpreadsheet.xlsx';
update(conn, 'userPassword', colnames, exdata, ...
'where Username =', fileSelected)
The problem is that instead of updating the password where Username = BobSpreadsheet.xlsx, it creates a new row with Username= BobSpreadsheet.xlsx and Password=NewPassword.
How do I update the password for BobSpreadsheet.xlsx without creating a new row ?
Any idea is welcome.
Thanks.