I have to count the number of occurrences of a record (x) in a Table "Stocks" from a database "MultiProductInventory"

1 次查看（过去 30 天）
Kallam Haranadha Reddy
评论： Kallam Haranadha Reddy 2016-8-15
I have to count the number of occurrences of a record (x) in a Table "Stocks" from a database "MultiProductInventory". The database table consists of 9 fields , the first field is the PI (Product Id) and the other fields are F1,F2,...,F8. The arguments for field variables Pi,F1,F2,..,F8 are supplied at run time from an array (x). I ran the following code. The MATLAB is giving error message, "Invalid or closed connection" and " Undefined function or method "fetch" for input argumnts of type struct. can any body explain me where is the mistake in the code.
function [ Pocc ] = Multiprodinv1(x)
dbpath = ['C:\ Users\admin\Documents\MultiProductInventory'];
url = [ [ 'jdbc:odbc:Driver = {Microsoft Access Driver(*.mdb,*.accdb)};DSN =' ';DBQ ='] dbpath];
conn = database('MultiProductInventory','','','Sun.jdbc.odbc.JdbcOdbcDriver',url);
query1 = ['select all ID from Stocks where PI=',num2str(x(1))];
query2=[''];
for fidx=1:8
query2 = strcat(query2,sprintf('and F%d=',fidx),num2str(x(fidx+1)));
end
query = strcat(query1,query2);
curs=exec(conn,['query']);
curs.Message
curs=fetch(curs);
y= curs.Data;
Pocc=length(y);

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

采纳的回答

the cyclist
the cyclist 2016-8-14
Looks like your database command is not finding the driver. It's difficult to give specific advice on this. I would suggest looking at the following:
  1 个评论
Kallam Haranadha Reddy
Kallam Haranadha Reddy 2016-8-15
Thanks. I learned that I have to install JAVA for using JDBC drivers. Any how, without using JDBC, i used ODBC drivers and ran the program. It gave the results.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by