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

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]

Please use the '{ } Code' button to format the code sections of your question.

Answer 1

[Brendan Hamm]

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

[Rohit Agnihotri]

Sir now i got the solution actually that was due to syntax error..Thanx for your reply.