Update after assigning From LOV [message #456028] |
Fri, 14 May 2010 03:15 |
rmaheshbabu
Messages: 10 Registered: April 2010 Location: INDIA
|
Junior Member |
|
|
In my form I added blk_dept (Dept Table consists Deptno-pk and Dname Columns)
with Insert, update, delete and view buttons
1) From view Button I called lov.
Lov displays all the department Number and Names and
It assigns block fields(blk_dept.deptno and blk_dept.dname)
2)After Assigning when I Press delete Button
Code Written is:
Delete from dept where deptno=:blk_dept.deptno;
Commit;
Browser Simply Processing long time without retrieving
any result or displaying Fields
If I written Code as
Delete Record;
Commit;
It Results
Frm 40401: No changes to save;
But It Not Deleting From The Table.
I think after Deleting it Inserting Same Record Is it?
3)When I press Update Button
update dept set dname=:blk_dept.dname where
deptno=:blk_dept.deptno;
commit;
It Results
Frm: 40508 oracle error unable to insert record
or
Browser Simply Processing long time without retrieving any
result or displaying Fields
Thanks and Regards
R.MaheshBabu
|
|
|
|
|