Home » Developer & Programmer » Forms » SET BLOCK STATUS in Forms 6i (Forms 6i)
SET BLOCK STATUS in Forms 6i [message #649437] Fri, 25 March 2016 09:27 Go to next message
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
Re: SET BLOCK STATUS in Forms 6i [message #649461 is a reply to message #649437] Sat, 26 March 2016 06:11 Go to previous messageGo to next message
Littlefoot
Messages: 21678
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);
Re: SET BLOCK STATUS in Forms 6i [message #649464 is a reply to message #649437] Sat, 26 March 2016 12:54 Go to previous messageGo to next message
adfnewbie
Messages: 54
Registered: January 2016
Member
Thanks! I will try and update
Re: SET BLOCK STATUS in Forms 6i [message #649498 is a reply to message #649464] Tue, 29 March 2016 03:18 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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?
Re: SET BLOCK STATUS in Forms 6i [message #649505 is a reply to message #649498] Tue, 29 March 2016 05:30 Go to previous message
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.
Previous Topic: Change Email Subject
Next Topic: Using DDE.request in UTF8 characters
Goto Forum:
  


Current Time: Tue Jun 22 05:42:59 CDT 2021