sqlfind() function not found

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!

[Walter Roberson]

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 ?

Answer 1

[Gouri Chennuru]

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!

Answer 2

[Pranav]

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)

[Steven Lord]

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]

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?