 After Printing ? [message #186973] |
Thu, 10 August 2006 06:45  |
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
|
Member |
|
|
Hi,
I want to do as :-
I call Report from Form, and After Report prints, The Status of the column named as 'PRINTED', should be changed to 'YES' or '1' in the employee table.
How i can do that...??
I've writen the code in 'After Report' as
Update empolyee
set printed=1
where serialno=:emp_id;
But It doesn't change the Printed Field to 1?
NOthing happens?
Regards
qadeer Ahmed
|
|
|
|
|
|
|
|
| Re: After Printing ? [message #187157 is a reply to message #187150] |
Fri, 11 August 2006 02:42  |
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
|
Member |
|
|
Thanks For Reply !!
Yes I did commit;
But Null Value is Inserted in the column.
I checked with this query.SELECT COUNT(NVL(printed,0)) from employee.
It counts to 3, If NVL function is not used, then it counts to 0 ?
Regards
Qadee Ahmed
|
|
|
|
| Re: After Printing ? [message #187180 is a reply to message #187157] |
Fri, 11 August 2006 04:12 |
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
|
Member |
|
|
Thanks You All,
My Problem is Solved
By Using SRW Package
SRW.DO_SQL('UPDATE BU_EMP_CARD SET PRINTED=1 WHERE EMPID='||:emp_id);
SRW.DO_SQL('COMMIT');
Regards
Qadeer Ahmed
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
