re-problem while insert into

dear sir

thanks for ur kind reply.

i will explain my problem now in detail.

i have only one data block in my form.

so there is no master-detail structure.

actually i am developing PAYROLL SYSTEM for my organization.

i want that when employee will scan his employee-card, his empcode will be filled in a text item and then against that empcode i have to show his picture and other details on the screen from table named as "EMPLOYEEINFO".
THEN
i will insert some data into an other table names as "EMPLOYEE_ATTENDANCE" such as his time-in etcs.

the data block name is "EMPLOYEEINFO" is made on table "EMPLOYEEINFO".

i code at "POST_TEXT_ITEM" of a text item named as "employeecode" THE FOLLOWING

------------------------
select name,EMPPIC
into :name,PICPATH from employeeinfo where empcode=:empcode;
READ_IMAGE_FILE(PICPATH, 'BMP', 'EMPPIC');


insert into attendanceinfo
values(:empcode,'sysdate',1);
COMMIT;
--------------------------

if i do not run "select statment" first then "insert into" works.

please tell me its solution.

regards.

M.RAZA UL HAQ
FAISALABAD PAKISTAN.