Index exceeds matrix dimensions error

8 次查看（过去 30 天）

obstac 2016-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302979-index-exceeds-matrix-dimensions-error

评论： Brendan Hamm 2016-9-15

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