OraFAQ Forum: Forms » COMMIT FORM

Home » Developer & Programmer » Forms » COMMIT FORM

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

COMMIT FORM [message #116662]

Thu, 21 April 2005 04:29

dbarone
Messages: 20
Registered: March 2005

Junior Member

Hi I have a problem, I created a Form and everything works pretty well. The only problem is that when I delete 5 or 6 records and then add another 5 or 6 records when I do commit_form
go_block
execute_query
The result of the query is wrong but on the database everything is saved correctly...
I tried with synchronize or a timer.....

Report message to a moderator

Re: COMMIT FORM [message #116674 is a reply to message #116662]

Thu, 21 April 2005 06:20

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

use Clear_Form built-in.

Report message to a moderator

Re: COMMIT FORM [message #116705 is a reply to message #116662]

Thu, 21 April 2005 09:03

dbarone
Messages: 20
Registered: March 2005

Junior Member

good idea but it doesn't work..I think it something bigger than that. I put another button in the block and in the trigger I inserted go_block and execute query..
so when i delete for example 3 records and press
Save it does commit_form, go_block and execute_query but the records displayed are not correct.. the records that i deleted reappear..But after that If I press my new button with the go block and execute query it works correctly.

Report message to a moderator

Re: COMMIT FORM [message #116755 is a reply to message #116662]

Thu, 21 April 2005 19:41

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

Senior Member
Account Moderator

Are you running master/detail? If yes, do you go to the master block before doing or execute-query?

David

Report message to a moderator

Previous Topic:	frm : 90928 positional parameter not specified ...
Next Topic:	Automatic Stock Level Notifications.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:44:51 CDT 2024