OraFAQ Forum: Forms » SET BLOCK STATUS in Forms 6i

Home » Developer & Programmer » Forms » SET BLOCK STATUS in Forms 6i (Forms 6i)

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

SET BLOCK STATUS in Forms 6i [message #649437]

Fri, 25 March 2016 09:27

adfnewbie
Messages: 54
Registered: January 2016

Member

Hi Guys!

How can I change the status of the block to any value like 'CHANGED'?
My requirement is -- I am not changing any data on form and issuing a commit so I am getting 'No changed to save' message dialog. I want to avoid that. I found a solution that using STANDARD.COMMIT will suppress that message. But I think if the property :SYSTEM.block_status is 'CHANGED', it will still suppress the message. So is there a way I can change to set the value of that property?

Thanks

Report message to a moderator

Re: SET BLOCK STATUS in Forms 6i [message #649461 is a reply to message #649437]

Sat, 26 March 2016 06:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You should change record status, not block status. Have a look at Forms Online Help system and search for SET_RECORD_PROPERTY; here's an example:

set_record_property(:system.trigger_record, :system.trigger_block, status, changed_status);

Report message to a moderator

Re: SET BLOCK STATUS in Forms 6i [message #649464 is a reply to message #649437]

Sat, 26 March 2016 12:54

adfnewbie
Messages: 54
Registered: January 2016

Member

Thanks! I will try and update

Report message to a moderator

Re: SET BLOCK STATUS in Forms 6i [message #649498 is a reply to message #649464]

Tue, 29 March 2016 03:18

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you're getting that message then no database items in the form have been changed so forms can't generate a standard insert/update statement to send to the DB. So what changes do you expect to get saved?

Report message to a moderator

Re: SET BLOCK STATUS in Forms 6i [message #649505 is a reply to message #649498]

Tue, 29 March 2016 05:30

adfnewbie
Messages: 54
Registered: January 2016

Member

I am changing something on the form, in fact several fields on the form but which are not database items. I am using insert statement to pick the values from these fields and insert in some table. For example, f1 and f2 are two fields which are database items, f3 is a non-database item which may or may not change depending upon f1 and f2. If its changed it has to go to some table which is not related to form in any way.

Report message to a moderator

Previous Topic:	Change Email Subject
Next Topic:	Using DDE.request in UTF8 characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 08 19:38:10 CDT 2025