Index exceeds matrix dimensions error

1 view (last 30 days)
obstac
obstac on 14 Sep 2016
Commented: Brendan Hamm on 15 Sep 2016
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
  4 Comments
Walter Roberson
Walter Roberson on 14 Sep 2016
What shows up for size(data) and class(data) ?
Brendan Hamm
Brendan Hamm on 15 Sep 2016
Seems to be a duplicate problem with a minor difference in the example. The issue is exactly the same though.

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!