Update database in gui but dont get updated data.

HI, i try to update database in gui, but my code dont working and dont get error also database not updated please help me. there is table:

code

function pushbutton2_Callback(hObject, eventdata, handles)
colnames = {'vardas','pavarde','laipsnis','pareigos','telefonas','marke','numeris','tarnyba'};
conn = database('baze', 'root', 'root', 'Vendor', 'MYSQL', 'Server', 'localhost', 'PortNumber', 3306);
set(conn, 'AutoCommit', 'on');
get(conn, 'AutoCommit');
update(conn, 'info', colnames,{handles.edit1,handles.edit2,handles.edit3,handles.edit4,handles.edit5,handles.edit6,handles.edit7,handles.edit8},['where id = ' sprintf('%f',handles.text9)])
close(conn);

Answer 1

[Geoff Hayes]

Gytis - in your command

 update(conn, 'info', colnames, ...
        {handles.edit1,handles.edit2,handles.edit3,handles.edit4,handles.edit5,handles.edit6,handles.edit7,handles.edit8},...
        ['where id = ' sprintf('%f',handles.text9)])

you are populating the cell array of values with the handles of the edit controls rather than the strings that have been entered in to each edit control. Rather than using the handle, you will need to extract the string first

 vardasValue = get(handles.edit1,'String');

(though this will depend upon which version of MATLAB that you are using).

[Gytis Raudonius]

im usin 2013 Matlab and i tried add you code but same problem no errors and not updated database

[Geoff Hayes]

Put a breakpoint in the code and then check to see what the command is that you are submitting to the database. Also, what is your where clause? Your code (unless changed) is

 ['where id = ' sprintf('%f',handles.text9)]

Again, you will need to do

 id = get(handles.text9, 'String');

and

 ['where id = ' id ]

[Gytis Raudonius]

i do this and i got this error Error using database/update (line 76) Number of whereclauses must be one or match the number of data records to be updated.

[Geoff Hayes]

Gytis - you will have to post all of your code so that I can see what you've written. From the error, it sounds like you have two where clauses...