SQlite Update command problem in Matlab

6 次查看（过去 30 天）

seu seu 2020-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505531-sqlite-update-command-problem-in-matlab

评论： Geoff Hayes 2020-2-19

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 个评论
显示 3更早的评论隐藏 3更早的评论

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.