Home » Developer & Programmer » Forms » Changing a block not base table (Oracle Forms 10)
Changing a block not base table [message #568664] Mon, 15 October 2012 11:52 Go to next message
robson.barata
Messages: 7
Registered: July 2012
Location: Brazil,Belo Horizonte,MG
Junior Member
Hi Guys !

How do I change the status of a block to change?
Ops: The block is not base table !!!

Att,

Robson.
Re: Changing a block not base table [message #568666 is a reply to message #568664] Mon, 15 October 2012 12:19 Go to previous messageGo to next message
joy_division
Messages: 4503
Registered: February 2005
Location: East Coast USA
Senior Member
I do not understand what you are asking and what is ops?
Re: Changing a block not base table [message #568668 is a reply to message #568666] Mon, 15 October 2012 12:44 Go to previous messageGo to next message
robson.barata
Messages: 7
Registered: July 2012
Location: Brazil,Belo Horizonte,MG
Junior Member
Sorry Joy!

I'll explain in detail.

I have a forms in which the blocks are not base table. when I do a query and then having to change it a given, it does not consider the last entered value on the screen. I think it's because the status of the block does not change.

I want to upgrade the database but he's putting out new values​​.

Ops is observation.

Att,

Robson.
Re: Changing a block not base table [message #568669 is a reply to message #568666] Mon, 15 October 2012 12:51 Go to previous messageGo to next message
Littlefoot
Messages: 19469
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How about SET_RECORD_PROPERTY, for example
set_record_property(1, '<block_name>', status, changed_status)
I can't test it, but you might need to loop through all records and set their status to CHANGED_STATUS.

By the way, why would you want to do that?

[EDIT] Didn't see your last message, sorry.

Is it necessary to use a control block for such operations? What's wrong with a database block? They are much better for querying, updating, inserting and deleting records than control blocks as - with control blocks - you have to code all that, manually.

So - did you tell Forms that you want to UPDATE a database record, based on values in a form?

[Updated on: Mon, 15 October 2012 12:53]

Report message to a moderator

Re: Changing a block not base table [message #568672 is a reply to message #568669] Mon, 15 October 2012 13:02 Go to previous messageGo to next message
robson.barata
Messages: 7
Registered: July 2012
Location: Brazil,Belo Horizonte,MG
Junior Member

I tried using a block base table, but it did not work because other validations. Now I'm trying to do manually.

Which trigger I can use this command?
Re: Changing a block not base table [message #568673 is a reply to message #568672] Mon, 15 October 2012 13:06 Go to previous messageGo to next message
Littlefoot
Messages: 19469
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What "other validations"? Perhaps we'd all be happier if you let Forms do the dirty job, and the community help you fix these validations.
Re: Changing a block not base table [message #568675 is a reply to message #568673] Mon, 15 October 2012 13:18 Go to previous messageGo to next message
robson.barata
Messages: 7
Registered: July 2012
Location: Brazil,Belo Horizonte,MG
Junior Member
Ok Joy!

I'll change to base table to simulate the problem again and publish the doubts.

Thank you !
Re: Changing a block not base table [message #568684 is a reply to message #568675] Mon, 15 October 2012 15:27 Go to previous message
joy_division
Messages: 4503
Registered: February 2005
Location: East Coast USA
Senior Member
robson.barata wrote on Mon, 15 October 2012 14:18
Ok Joy!

I'll change to base table to simulate the problem again and publish the doubts.

Thank you !


Joy, as in you are happy, because it was Littlefoot who gave the suggestion.
Previous Topic: how to use when-validate-item in enter-query mode
Next Topic: Frm-92101
Goto Forum:
  


Current Time: Thu Aug 21 00:03:23 CDT 2014

Total time taken to generate the page: 0.09686 seconds