Index exceeds matrix dimensions error

obstac

2016 9 14

0 个回答

16 次查看（30 天）

0 个投票

i have database named 'data' , in gui i have 3 editbox which are name,gpa,salary and a push button . have data in database like this :

field= {'name','gpa','salary'};
data = {'Andre',3.2,$1000};

my program like this :

conn = database('db1_mysql','root','');
sql = ['select * from data where name =','''',handles.name,''''];
data = fetch(conn,sql)
handles.data = data;
guidata(hObject,handles)
if isempty(data)
  msgbox('data not found')
  set(handles.gpa,'String','')
  set(handles.salary,'String','')
else
  set(handles.gpa,'String',data(1,2))
  set(handles.salary,'String',data(1,3))
end

what i want is if i type Andre in name editbox in gui , his gpa and salary show up in others edit box . but i'm getting error : Index exceeds matrix dimensions. my database have 1 row , and 3 coloumn . how can it not working . Im using matlab R2016a