Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
languagematlab
cData = execfetch(conn,SQL,'DataReturnFormat','cellarray');
c=fetch(c);
if rowssize(cData,1) > 0
  ...

...


end

Old - to replace

Code Block
languagematlab
Datacurs = fetchexec(conn,SQL,'DataReturnFormat','cellarray');
curs=fetch(curs);
if rows(curs) > 0
   A.num_studies(i) = size(Data2,1);...
end
close(curs)