OraFAQ Forum: Forms » use no_validate but not save my data

Home » Developer & Programmer » Forms » use no_validate but not save my data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

use no_validate but not save my data [message #165102]

Tue, 28 March 2006 06:00

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master

sir i use exit_form(no_validate);

but sir system not save my date

please sir give me idea or code how i save my record

thanking you

Aamir

Report message to a moderator

Re: use no_validate but not save my data [message #165219 is a reply to message #165102]

Tue, 28 March 2006 23:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please read the 'exit_form' entry in the Forms reference manual. If you want to save your changes then either use the default 'ASK_COMMIT' or "don't ask the user, just save it" 'DO_COMMIT' option of the 'exit_form' command.

David

Report message to a moderator

i use ask_commit and exit_form(do_commit) but not solve my problem [message #165228 is a reply to message #165219]

Wed, 29 March 2006 00:24

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master

when i delete any record then i face problem
sir i give you my full working

step 1

on delete button i writh this

begin
go_block('chartofacc');
delete_record;
end;

on save button i writh this

BEGIN
if :system.form_status='CHANGED' then
commit_form;
execute_query(no_validate);*/
if :system.form_status='QUERY' then
item_enable_disable(property_off);
end if;
end if;

on exit button i writh this

begin
Exit_Form(ASK_COMMIT) ;
/* Exit_Form(DO_COMMIT); */
end;

both use one by one but not save and show window with this message

Do you want to save the changes you have made?

YES NO CANCEL

i need system not ask by user and save my changing

sir please give me idea
thanking you
Aamir

Report message to a moderator

Re: i use ask_commit and exit_form(do_commit) but not solve my problem [message #165398 is a reply to message #165228]

Wed, 29 March 2006 21:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

The 'Exit_Form(DO_COMMIT)' should work. You DO have to remove the '/* */' comment handles. Put them around the 'Exit_Form(ASK_COMMIT)' instead.

David

Report message to a moderator

Re: i use ask_commit and exit_form(do_commit) but not solve my problem [message #165413 is a reply to message #165398]

Wed, 29 March 2006 23:57

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir when i use Single quotation and complie then give me error

'Exit_Form(DO_COMMIT)';

illegal statement

how i handle this

Thanking You
Aamir

Report message to a moderator

Re: i use ask_commit and exit_form(do_commit) but not solve my problem [message #165414 is a reply to message #165413]

Thu, 30 March 2006 00:03

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please remove the quotes from around the statement.

Also, please look at the code that you posted previously as it appears to have a trailing '*/' (end-of-comment handle) which should be removed.

David

Report message to a moderator

cascade delete problem [message #165421 is a reply to message #165413]

Thu, 30 March 2006 01:01

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir

this problem in only delete case
i set cascade relation when i press exit button system ask me do you save change i press yes button but system not exit stand last position no delete record

how i delete the record plseas give me idea

Report message to a moderator

Re: cascade delete problem [message #165422 is a reply to message #165421]

Thu, 30 March 2006 01:19

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir i test without qutation but my problem still

you see my actuale problem

sir

i facing problem only in delete case
i have master detail form i set cascade relation when i delete button code is

go_block('chartofacc');
delete_record;
commit_form;

when press exit button system ask me do you want to save change i press yes button but system not delete record and not exit stand last position and show that record

how i delete my master record with child

please give me idea how

thanking you

Aamir
how i delete the record plseas give me idea

Report message to a moderator

Re: cascade delete problem [message #165562 is a reply to message #165422]

Thu, 30 March 2006 23:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I suggest that you go back to the beginning. Read the various 'master detail' threads that have be created here lately. Then, start a new form, use the wizards to create the blocks, and then the 'relations'. The delete can be cascaded but not nicely or obviously through manual triggers, so use the default behaviour that Forms provides.

David

Report message to a moderator

Previous Topic:	go_item
Next Topic:	When-Mouse-DoubleClick Not working on some machines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 16 22:33:10 CDT 2026