OraFAQ Forum: Forms » Changing a block not base table

Home » Developer & Programmer » Forms » Changing a block not base table (Oracle Forms 10)

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

Changing a block not base table [message #568664]

Mon, 15 October 2012 11:52

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.

Report message to a moderator

Re: Changing a block not base table [message #568666 is a reply to message #568664]

Mon, 15 October 2012 12:19

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I do not understand what you are asking and what is ops?

Report message to a moderator

Re: Changing a block not base table [message #568668 is a reply to message #568666]

Mon, 15 October 2012 12:44

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.

Report message to a moderator

Re: Changing a block not base table [message #568669 is a reply to message #568666]

Mon, 15 October 2012 12:51

Littlefoot
Messages: 21813
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

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?

Report message to a moderator

Re: Changing a block not base table [message #568673 is a reply to message #568672]

Mon, 15 October 2012 13:06

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: Changing a block not base table [message #568675 is a reply to message #568673]

Mon, 15 October 2012 13:18

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 !

Report message to a moderator

Re: Changing a block not base table [message #568684 is a reply to message #568675]

Mon, 15 October 2012 15:27

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	how to use when-validate-item in enter-query mode
Next Topic:	Frm-92101

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 06 09:25:57 CDT 2024