Unable to access records using next_record.
I have used text items to hold the data from the database. I used the following query on WHEN-BUTTON_PRESSED trigger
DECLARE CURSOR records_cur
IS SELECT rollno, accno, name, f_name, branch, dob, passwd, mobile
FROM studententries;
BEGIN
FOR cur_count IN records_cur
LOOP
:form_roll_no := cur_count.rollno;
:form_account_no := cur_count.accno;
:form_name := cur_count.name;
:form_father := cur_count.f_name;
:form_branch := cur_count.branch;
:form_dob := cur_count.dob;
:form_passwd := cur_count.passwd;
:form_mobile := cur_count.mobile;
next_record;
END LOOP;
END;
I am however unable to access the records using this application. Please comment whether this is the correct usage or not.
Edited by: Ankur Raina on Oct 16, 2012 4:17 AM