SQlite Update command problem in Matlab

6 views (last 30 days)
seu seu
seu seu on 14 Feb 2020
Commented: Geoff Hayes on 19 Feb 2020
Hi,all
I do not know why the reason happens when I use command "update" in Matlab to update my SQlite database. The connection 'conn' between Matlab and SQlite database is normal. My PC is on Windows10. The version of Matlab is R2019b.
DatabaseProductName: 'SQLite.
DatabaseProductVersion: '3.30.1'
DriverName: 'SQLite JDBC'
DriverVersion: '3.30.1
rowid username password
1 220171591 220171591
2 admin admin
update(conn,'Login','password',{'ADMIN'},{'WHERE username = ''admin'''})
the mistake matlab give below:
Undefined function 'update' corresponding to input parameters of type 'sqlite'
Is that means anything wrong with my Version of SQlite and Matlab.
Thanks.
  5 Comments
seu seu
seu seu on 19 Feb 2020
insert,delete,fetch,but the command 'update' seems do no work to the sqlite database. according to the help docfile, the command 'update' just work for SQL database.
Geoff Hayes
Geoff Hayes on 19 Feb 2020
Please type the following into your command window
which update -all
What is returned by the above? It should list all of functions named update. Perhaps there is a conflict.

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!