sqlfind() function not found

2 次查看（过去 30 天）
Yifat Salman
Yifat Salman 2020-12-20
编辑： Pranav 2023-7-18
Hi everyone,
I would like to see the table names available and column names within those tables for an sqlite database stored as 'mydb.db', by using the MATLAB interface for sqlite. I read that sqlfind() has this functionality, but the function is not being recognized by my MATLAB (having installed the 'database toolbox' extension).
Is it possible to use this function without installing a JDBC driver? Or is there an alternative for the MATLAB interface to SQLite?
Thank you in advance for your help!
  1 个评论
Walter Roberson
Walter Roberson 2020-12-20
Hmmm, sqlfind() should be present if you have the Database Toolbox installed and licensed, R2018a or later.
Are you able to use other functions from the Database Toolbox ?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Gouri Chennuru
Gouri Chennuru 2020-12-27
I would recommend you to check whether the database toolbox is installed correctly or not by executing ver command in MATLAB command prompt.
You can refer to product requirements of database toolbox whether all the requirements and make sure all are available in your MATLAB.
https://www.mathworks.com/support/requirements/database-toolbox.html
Hope this Helps!
Pranav
Pranav 2023-7-18
Hi,
I am using MATLAB 2020b and have the same problem - 'Unrecognised function or variables 'sqlfind''. Any ideas what the issue might be?
MATLAB Version: 9.9.0.2037887 (R2020b) Update 8
Operating System: Microsoft Windows 10 Enterprise Version 10.0 (Build 19044)
Java Version: Java 1.8.0_202-b08 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
-----------------------------------------------------------------------------------------------------
MATLAB Version 9.9 (R2020b)
Database Toolbox Version 10.0 (R2020b)
Datafeed Toolbox Version 5.9.2 (R2020b)
Financial Toolbox Version 6.0 (R2020b)
MATLAB Compiler Version 8.1 (R2020b)
MATLAB Compiler SDK Version 6.9 (R2020b)
Optimization Toolbox Version 9.0 (R2020b)
Parallel Computing Toolbox Version 7.3 (R2020b)
Spreadsheet Link Version 3.4.4 (R2020b)
Statistics and Machine Learning Toolbox Version 12.0 (R2020b)
  2 个评论
Steven Lord
Steven Lord 2023-7-18
Can you show us exactly how you're trying to call sqlfind as well as the types and sizes of the variables that you're using as inputs in your sqlfind call? I want to confirm that you're calling sqlfind in a way that the function in Database Toolbox supports (in particular, that you're calling it with a connection object as the first input.)
Pranav
Pranav 2023-7-18
编辑：Pranav 2023-7-18
Hi Steven,
I am doing the below:
dbfile = 'test.db';
conn = sqlite(dbfile);
sqlfind(conn, '');
The output for conn is below and i can insert into test.db and read from it
conn =
sqlite with properties:
Database: 'test.db'
IsOpen: 1
IsReadOnly: 0
Either way i cant ctrl+D into sqlfind and even typing sqlfind into the command window leads me to an 'unrecognised function or variable' error which i assume shouldn't happen if the inputs are wrong?
I am also finding i cant execute sql commands using 'exec(conn, sqlquery)' function unless its a table creation (which works). Is it a problem specific to how MATLAB interfaces with sqlite or am i doing something completely wrong?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB Interface to SQLite 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by