I have a database with two tables. I tried to extract the data from the tables and i was able to extract also using the command below,
rs=invoke(hopen,'OpenRecordset','Data'); fieldlist=get(rs,'Fields');ncols=get(fieldlist,'Count');for c=1:double(ncols) fields{c} = get(fieldlist,'Item',c-1); resultset.columnnames{c} = get(fields{c},'Name'); end; nrecs=0; while get(rs,'EOF') == 0 nrecs = nrecs + 1; for c=1:ncols resultset.data{nrecs,c} = get(fields{c},'Value'); end; invoke(rs,'MoveNext'); end
Only problem is when I have a multiple values in the cell i can able to extract only first element in the cell.
For example,
in the above figure, the column carsSelected consists of multiple value in the cell. In this case i cannot able to extract all the elements in the cell? How can I do this?
Thanks a lot
Best Answer