SQlite Update command problem in Matlab

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 件のコメント

Geoff Hayes
Geoff Hayes 2020 年 2 月 14 日
seu - is connect valid for SQLite? Try looking at SQLite connection and the available functions (from this page) that can be used to execute SQL statements against STLite databases.
seu seu
seu seu 2020 年 2 月 15 日
The connect is valid, I can insert and delete in SQlite database
Geoff Hayes
Geoff Hayes 2020 年 2 月 18 日
So does a problem only occur when you want to modify a record? What code do you use for those commands that work?
seu seu
seu seu 2020 年 2 月 19 日
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 2020 年 2 月 19 日
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.

サインインしてコメントする。

回答 (0 件)

タグ

質問済み:

2020 年 2 月 14 日

コメント済み:

2020 年 2 月 19 日

Community Treasure Hunt

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

Start Hunting!

Translated by