avoid "no changes to save" error in module

[amr]

i want from you to make a button in form using scott.emp insert value in another
table for example mytable without showing any message error,
no person can make this

[debasisdas]

dear amr

u question is not at all clear

if u really want some reply, post your question in a correct format so that others can also understand.
please avoid the type of heading u have used for your question.

[vijaydiwakar]

i want from you to make a button in form using scott.emp insert value in another
table for example mytable without showing any message error,
no person can make this

Dear I think ur Q language is more difficult to understand than the actual problem itself
make it easy to understand other
bbye and take care

[amr]

i made data block in one module ,this data block is connected to emp table
and i made button in this module ,and i create table its name is temp
and i write when_button_pressed

delete temp;
insert into temp(t1)
values('a');
commit;

when i run the module and press this button the error message appeare to me
no changes to save,i want to avoid this,plz help me,
and i am so sorry i am not english man

[parag100]

i made data block in one module ,this data block is connected to emp table
and i made button in this module ,and i create table its name is temp
and i write when_button_pressed

delete temp;
insert into temp(t1)
values('a');
commit;

when i run the module and press this button the error message appeare to me
no changes to save,i want to avoid this,plz help me,
and i am so sorry i am not english man

u write in sql editor
when_button_pressed

delete temp;
insert into temp(t1)
values('a');
commit_form;

let see it should run

[masdi2t]

i made data block in one module ,this data block is connected to emp table
and i made button in this module ,and i create table its name is temp
and i write when_button_pressed

delete temp;
insert into temp(t1)
values('a');
commit;

when i run the module and press this button the error message appeare to me
no changes to save,i want to avoid this,plz help me,
and i am so sorry i am not english man

can you show us thus error message. and could you tell us more clearly about what tool you working with

[UshaS]

Change your code as mentioned below. It will prohibit displaying of message "No changes to save" on the screen.

delete temp;
insert into temp(t1)
values('a');
:SYSTEM.MESSAGE_LEVEL := '5';
commit;
:SYSTEM.MESSAGE_LEVEL := '0';

i made data block in one module ,this data block is connected to emp table
and i made button in this module ,and i create table its name is temp
and i write when_button_pressed

delete temp;
insert into temp(t1)
values('a');
commit;

when i run the module and press this button the error message appeare to me
no changes to save,i want to avoid this,plz help me,
and i am so sorry i am not english man