Hey guyzz
I am facing a problem in MATLAB..
I have a column named 'address' of type text in 'Table1' and the its an MS ACCESS database...Now i want to update the row where roll=3 with the string 'hell' in matlab.....i m using the following command...
update(connA,'Table1',{'address'},{hell},'where roll=''3''');
Now it is giving the error as
??? Error using ==> database.update at 180
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
Error in ==> db at 96
update(connA,'Table1',{'address'},{hell},'where roll=''3''');
Will post the solution as soon as i get to know..:
Gosh!! This problem freaked me for soo long..
ReplyDeleteI got to know where i was wrong... Actually the last parameter of update function should be first taken in variable..It should look like this
whereclause = 'where roll=3 ';
update(connA,'Table1',{'address'},data,whereclause);
where 'data' is a cell array..