...
R2021a - rows and database return
SQL = ['SELECT study.examno,study.series,study.name, projectgroupstudymri.type, ',...
'analysisfmritype.task,analysisfmritype.chaltype FROM study ',...
'INNER JOIN projectgroupstudymri ON projectgroupstudymri.study_id=study.study_id ',...
'INNER JOIN analysisfmritype ON analysisfmritype.analysisfmritype_id=projectgroupstudymri.analysisfmritype_id ',...
'WHERE projectgroupstudymri.projectgroupstudymri_id=',int2str(projectgroupstudymri_id)];
...
New
Code Block | ||
---|---|---|
| ||
cData = execfetch(conn,SQL); c=fetch(c,'DataReturnFormat','cellarray'); if rowssize(cData,1) > 0 ... end close(c) |
...
Old - to replace
Code Block | ||
---|---|---|
| ||
Datacurs = fetchexec(conn,SQL,'DataReturnFormat','cellarray'); curs=fetch(curs); if sizerows(Data,1curs) > 0 ... end close(curs) |