Do u want to save the changes [message #397335] |
Fri, 10 April 2009 02:11  |
sivajyothi.kalikiri
Messages: 29 Registered: March 2009
|
Junior Member |
|
|
Hi,
I designed one form such that, when i enter emp_code and clicked on ok button, I should get all the details corresponding to that code.
if there is no data corresponding to that code means i should get an message as 'NO ENTRY MADE FOR THIS EMPLOYEE';
I wrote the following code in the when button pressed trigger
DECLARE
BEGIN
go_block('M_AUTHORITY') ;
set_block_property( 'M_AUTHORITY' ,DEFAULT_WHERE, ' WHERE emp_code = ' || '''' || :m_authority.emp_code || '''' ) ;
execute_query;
set_block_property('M_AUTHORITY', DEFAULT_WHERE, '');
But I am getting an alert 'Do U Want To Save The Changes',when i click on the button, though no changes made.
when no data is availale also the same message i am getting.
In order to get'no entry made.......'message where i have to write the code,if no data is found corresponding to that emp_code.
please help me to solve this problem.
|
|
|
|
|
|
|
|
|
|