Hi Lava Citizens,
I am trying to implement SQLite - update function so i can easily modify values in a selected row.
http://www.sqlitetutorial.net/sqlite-update/
I have tried this statement - UPDATE ESD_User SET Name = 'James Bond', Status = 'Employee', Location = 'Canada' WHERE EmployeeID = 5; using the DB Browser for SQLite. The command does update the values as expected.
I am trying to do same with the labview + sqlite driver. I have attached the update user code.
I am getting an error from EXEC SQL
"SQLite.lvlib:Connection.lvclass:Execute SQL (Single String).vi:760001:Step on "UPDATE ESD_User SET Name = 'James Bond', Status = 'Employee', Location = 'Canada' WHERE EmployeeID = 5;"
SQLITE_BUSY: database is locked."
Can you please explain the cause of this error?
Thank you,
max