Dear Mr.SHAFIQUE RE- PROBLEM WHILE "INSERT INTO" COMMAND

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.

Actually you did not read my solution carefully that I sent you last time, anyway I made the small changed in your code marked by red color, see it below:

select name,EMPPIC
into :name,PICPATH from employeeinfo where empcode=:empcode;

READ_IMAGE_FILE(PICPATH, 'BMP', 'EMPPIC');

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

:SYSTEM.Message_Level := 10;
COMMIT_FORM;
:SYSTEM.Message_Level := 0;

The probelm was you are not committing the record, your query was working perfectly, you need to save it into database.

One more thing that I want to share with you that please don't use the individual's name in your question because this is not a one to one forum, If you use any person's name in title of your question, other people would think this matter is concern with both of us. If I am a busy then other people will gladly reply you but if you posted my name then other peopl might (may be or may be not) reply you. Please take care next time.

Thanks