I am inserting the records from cursor. but only one top record is inserting.



SELECT student.*, Level.*,exam.*;
FROM ;
student,exam ;
INNER JOIN level ;
ON Student.lcode = Level.code;
WHERE scode=thisform.scode.value and lcode=thisform.lcode.Value;
and sec=thisform.sec.value and admtd=1 AND exam.code=thisform.code.value INTO CURSOR examre1

zpath=path
zbex=bex_a
zmonth=Nmonth
zscode=scode
zlcode=lcode
zsec=sec
zexamcode=code_c

INSERT INTO examtran (ttpath,bex,nmonth,scode,lcode,sec,examcode);
values (zpath,zbex,zmonth,zscode,zlcode,zsec,zexamcode)
what is mistake?thanks