[RBG7-L] - RE: Scrolling regions- variables vs columns

[Javier Valencia]

Dennis: If you upgrade the value of a plain variable from an EEP it will display the same value on all rows. If you want to upgrade the value of a variable that is unique to each row, then you need to define a variable in the form and make it unique by linking it to some column in the row. For example, let say that you have a column direction that can be: E, W, N, S and then you want to display a variable vdir_desc that shows: East, West, North, South depending on the value of direction. If you upgrade the value of vdir_desc to “EAST” from within an EEP, then all the rows will display “EAST” as the value of the variable. What you would need to do is to create a look-up table (columns direction and dir_desc)  and then define the variable vdir_desc as: dir_desc in your_lookup_table WHERE direction = direction and now, whenever you change the value of direction, the variable vdir_desc will display the correct narrative. if you have only a couple of values, instead of using a lookup table, you can create a variable vtemp_direction = direction in the form and then you can you can use an _expression_ for the variable vdir_desc such as: IFEQ(,vtemp_direction,’N’,’North’,’South’) I hope that this is what you were looking for… Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Dennis Fleming Sent: Monday, July 25, 2005 10:08 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Scrolling regions- variables vs columns   RB7.1 In a form I have an EEP (on an object) which updates a variable and a column in a scrolling region. The column value works fine and only changes the focused row. I've tried all the combinations I can think of with the variable (update in variable expressions, using the EEP and component ID, etc., but it always changes all rows. Any suggestions appreciated. Dennis ***** Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Mobile: 570 351-5290