Notes
Re: Notes
Yes, I exported it as below.
A = csdb file
A = csdb file
Code: Select all
PROC DUMMY2_FF
numeric num = sqlquery( A , entrySessions,"select cases.key, notes.field_name, notes.record_occurrence, notes.content from notes join cases on notes.case_id = cases.id");
do numeric ctr = 1 while ctr <= num
NOTES_A.ID=entrySessions(ctr,1);
NOTES_A.FIELD=entrySessions(ctr,2);
NOTES_A.RECORD_OCC=tonumber(entrySessions(ctr,3));
NOTES_A.NOTES_NOTE=entrySessions(ctr,4);
writecase(NOTES_A);
enddo;
Last edited by Enkhbayar on January 27th, 2020, 9:21 am, edited 1 time in total.