Index exceeds matrix dimensions error
1 view (last 30 days)
Show older comments
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
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.
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!