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

horzcat

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)'];

Best Answer

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)'];
Related Question