This was a form, not a report. The problem I have had in the past with Getproperty is that it propagates the variable into every row with that component id. But thanks anyway.
Dennis
*****
At 11:13 AM 8/17/2005, you wrote:
Instead of a report variable, use an eep based on the entered value of Equip_number.
Set a component id in the Equip_Number property.
use GETPROPERTY vNo TEXTVALUE 'vPartNo'
in your eep where vNo is the component id and vPartNo will contain the text value of Equip_Number.
Then you can do a select to get the description.
Then use PROPERTY TABLE <FormTableName> 'REFRESH'
Bernie Lis
----- Original Message ----- From: "Dennis Fleming" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, August 17, 2005 10:01 AM
Subject: [RBG7-L] - Scrolling Region behavior
Looking for a workaround to avoid "slot machine" behavior for variable look ups.
Scrolling region rows have two popup dbedit values and form flashed through all possible values for a different variable after popup is selected and you move to the next row, making form run very slow. In from Variables:
vEquipDesc = Equip_Desc in Equipment where Equip_Number = Equip_Number
After selecting the popup value for a different column in the row and moving to the next row, all possible values for vEquipDesc are displayed on the row you just left.
Anyone else observe this behavior and/or have a fix/workaround?
TIA,
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
