I am connecting the database to matlab and compairing the z in matlab with the actual values in database

1 次查看（过去 30 天）
Rohit Agnihotri
Rohit Agnihotri 2015-7-14
评论： Rohit Agnihotri 2015-7-15
for i=1:100 k(i)=b(i); z=k(i) %s = cell(i,2); % fetchbatchsize=34; %sqlquery='select q_index from dataexport where q_index=(select ALL var_matlab FROM datavariable)';
% sqlquery='SELECT ALL q_index FROM dataexport WHERE q_index =Any (select var_matlab from datavariable)'; sql=['select id from dataexport where q_index=' num2str(z)'];
end
??? Error using ==> horzcat CAT arguments dimensions are not consistent.
Error in ==> compare1 at 17 sql=['select id from dataexport where q_index=' num2str(z)'];

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

采纳的回答

Brendan Hamm
Brendan Hamm 2015-7-14
Likely this is because you are transposing the result of
num2str(z)
Notice the error shows:
sql=['select id from dataexport where q_index=' num2str(z)'];
which is fine if z is a column vector
z= [1;4];
sql=['select id from dataexport where q_index=' num2str(z)'];
If it is a row vector, you will get an error about horizontal concatenation:
z= [1 4];
sql=['select id from dataexport where q_index=' num2str(z)'];

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by