[Openroad-users] problem with optionfields in a tablefield

[Chris Wallace]

Hans,

 

Can you please provide a little more explanation of what you are trying to achieve.

 

Do you mean that you want to change the option available in Field 2 depending on a selection made in Field 1?

 

ie.   Field 1           Field 2

      A---------------------abc

                         |--def

                         |--ghi

 

      B---------------------123

                         |--456

 

      C---------------------shj

                         |--dkl

 

There are limitations with addressing the Protofield of a Tablefield when you have multiple fields in a cell.  What you probably need to do is use a nested tablefield.  Include the OptionFields as individual columns in the embedded tablefield,  change the orientation to Horizontal so they appear one above the other (which is what I think you are trying to achieve).  Then use the ON SETVALUE event to trigger the changing of the Protofield in the other field.

 

Another option is to use a pair of floating Optionfields.  

1.	Define to Entry fields in the Tablefield cell, you want to have a couple of invisible fields to hold the OptionField Value or Code also.
2.	On entry to the tablefield cell position the floating Optionfield over the Cell, make the Optionfields (or stackfield container visible) and set focus to the first field.
3.	Use ON SETVALUE on the first Optionfield to trigger the change to the second Optionfield.
4.	Then ON SETVALUE of the second Optionfield, save the selections from both Optionfields to the underlying Tablefield EntryFields and make the OptionFields invisible.

 

I do have an examples of both of these somewhere.  If you need further assistance I'll try to locate them.

 

Regards

Chris Wallace
Management Information Systems (WA) Pty Ltd
Level 9, MIS House
231 Adelaide Terrace, PERTH  WA  6000
Ph: (08) 9221-9221  Fax: (08) 9221-9224
Email: chrisw at miswa.com.au
Web: http://www.miswa.com.au

Disclaimer <http://www.miswa.com.audisclaimer/> :  Management Information Systems (MIS)
This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of MIS unless this is clearly indicated.  You should scan this e-mail and any attachments for viruses.  MIS accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail.

________________________________

From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of hans.weisenberger at mmm.com
Sent: Tuesday, 21 August 2007 17:49
To: International OpenROAD Users
Subject: [Openroad-users] problem with optionfields in a tablefield

 

3M Deutschland GmbH
Sitz: 41453 Neuss * Handelsregister: B 1878 Amtsgericht Neuss 
Geschäftsführer: Jürgen Jaworski * Josef Mrozek * Theo Nöcker * Kurt-Henning Wiethoff * Managing Director: Kurt-Henning Wiethoff * Vorsitzender des Aufsichtsrates: Reinhold Hiersemann 

________________________________


Hi all,

I have the following problem in OR 4.1 on windows:

I have an tablefield (field3). In that tablefield there is one column (column1) with two optionfields (field1 and field2).

So when I click in the frameeditor I get: Optionfield 'field3[*].column1.field1' or Optionfield 'field3[*].column1.field1'

What I want is, depending on changing one optionfield, I want to change the other. 
But all tries to adress one of the optionfield leads to compilationerrors.

Does anyone have an idea how to solve that?

Thanks and greetings

Hans Weisenberger=

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20070821/0a7d2c90/attachment.html