Just as my last shred of sanity was slipping away.
That will work where I want a popup for the user to pick 1 of 3 values and use expressions for (IFEQ(...
Down the road it would be nice to have more of the form options work in a scrolling region.
Best Regards,
Dennis
*****
At 11:35 AM 7/25/2005, you wrote:
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: [email protected] [ 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
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
