FILL DATABLOCK!
448451Oct 19 2005 — edited Oct 20 2005Hello guys,
I have a datablock which is no database block and i fill it manual. I have a cursor for being more specific, and i fill the block line by line like:
OPEN efhmeries;
GO_RECORD(cnt);
FETCH efhmeries INTO
:EMPLOYEE_ID, :SERVICE, :SECTOR, :DEPARTMENT, :EF_DATE,
:DAYS_EFHMERIVN, :MISTHOLOGIO_ID, :POST_ID, :SEIRA, :DESCRIPTION,
:SURNAME, :C1, :C2, :C3, :C4, :C5, :C6, :C7, :C8, :C9, :C10,
:C11, :C12, :C13, :C14, :C15, :C16, :C17, :C18, :C19, :C20,
:C21, :C22, :C23, :C24, :C25, :C26, :C27, :C28, :C29, :C30, :C31;
WHILE efhmeries%FOUND LOOP
cnt := cnt+1;
GO_RECORD(cnt);
FETCH efhmeries INTO
:EMPLOYEE_ID, :SERVICE, :SECTOR, :DEPARTMENT, :EF_DATE,
:DAYS_EFHMERIVN, :MISTHOLOGIO_ID, :POST_ID, :SEIRA, :DESCRIPTION,
:SURNAME, :C1, :C2, :C3, :C4, :C5, :C6, :C7, :C8, :C9, :C10,
:C11, :C12, :C13, :C14, :C15, :C16, :C17, :C18, :C19, :C20,
:C21, :C22, :C23, :C24, :C25, :C26, :C27, :C28, :C29, :C30, :C31;
END LOOP;
CLOSE efhmeries;
unfortunately when i am running the program, it displays 1 line each time, and not all the lines in the datablock. My cursor contains 4 lines, and before go_record i put a message to catch the result, and i see that it displays me the right results, but one each time.
What can i do?
Any idea?
It's significant enough.
Thanx in advance,
Regards Bill...