Home » Developer & Programmer » Forms » MULTIRECORD BLOCK, INSERT_ALLOWED (FORMS DEVELOPER 10G)
MULTIRECORD BLOCK, INSERT_ALLOWED [message #498346] Wed, 09 March 2011 13:54 Go to next message
cemeli
Messages: 6
Registered: March 2011
Junior Member

Dear Sirs,

I have a multirecord block, which, once filled, I do not want to
allow manual insertions from the last new record.

For that, I do:
set_block_property('block name', insert_allowed, property_false)

The problem comes, when I want to change a checkbox item column from one record already informed.

I can not do that, after setting the block property, althought I change item properties accordingly.

Any ideea ?

Best regards
Ignacio

Report message to a moderator

Re: MULTIRECORD BLOCK, INSERT_ALLOWED [message #498352 is a reply to message #498346] Wed, 09 March 2011 14:15 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But, isn't that action (modifying checkboxes' value) UPDATE, not INSERT?

If not: I can't test now, but - perhaps you'll have to set ITEM properties (instead of block ones) to FALSE (except for the checkbox).

Report message to a moderator

Re: MULTIRECORD BLOCK, INSERT_ALLOWED [message #498459 is a reply to message #498352] Thu, 10 March 2011 01:13 Go to previous messageGo to next message
cemeli
Messages: 6
Registered: March 2011
Junior Member

The question is, do not allow new records in the multirecord, and at the same time, allow modify only checkbox column on the informed records.

Please, help.

Regards
Ignasi

Report message to a moderator

Re: MULTIRECORD BLOCK, INSERT_ALLOWED [message #498583 is a reply to message #498459] Thu, 10 March 2011 05:54 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Set insert allowed to no at block level.
Set update allowed to yes at block level.
Set update allowed to no for all items individually except the checkbox.

Report message to a moderator

Re: MULTIRECORD BLOCK, INSERT_ALLOWED [message #498778 is a reply to message #498346] Fri, 11 March 2011 01:53 Go to previous messageGo to next message
cemeli
Messages: 6
Registered: March 2011
Junior Member


Take into account that the multirecord block is not based on a
table.

I tested the solution given above, It does not work

Regards

Report message to a moderator

Re: MULTIRECORD BLOCK, INSERT_ALLOWED [message #498781 is a reply to message #498778] Fri, 11 March 2011 02:13 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you should explain what is a problem you are trying to solve. For example, what do you do with all those non-database records?

Option I mentioned in my previous post was: don't allow UPDATE for all items (one by one) but the checkbox item. Did you test that too?

Report message to a moderator

Re: MULTIRECORD BLOCK, INSERT_ALLOWED [message #498785 is a reply to message #498346] Fri, 11 March 2011 02:28 Go to previous message
cemeli
Messages: 6
Registered: March 2011
Junior Member

The solution given works for database blocks, but it is not the
case.

My multirecord block is not database, is filled differently.

I tested all the ways around, but no use.

Thanks

Report message to a moderator

Previous Topic: Forms Did not fit to screen
Next Topic: MS Word and OLE Container
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 04:58:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.