Nice explanation, Javier - I think that this is a difficult one to understand as well as seeming to have to fly through a few loops to get what's wanted.
 
I still have problems with getting the correct display of variables and data in Scrolling Regions and have been experimenting with saving the row and then using the Property command to refresh the table which seems to be giving me better results...
 
Regards,
Alastair.
 
----- Original Message -----
Sent: Monday, July 25, 2005 4:35 PM
Subject: [RBG7-L] - RE: Scrolling regions- variables vs columns

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
Phone: 570 775-7593
Mobile: 570 351-5290

Reply via email to