APPEND JobOrder2 TO tSelectedValues WHERE Assembly# = .vAssyjob WHERE LIMIT = 1 PROPERTY Comp_Assy REFRESHLIST 'TRUE' PROPERTY Comp_SelectedKits REFRESHLIST 'TRUE' RETURN
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, May 26, 2011 3:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - VARLISTVIEW I use 7.6. In my varlist view on click EEP I have this code: APPEND JobOrder2 TO tSelectedValues WHERE Assembly# = .vAssyjob PROPERTY Comp_Assy REFRESHLIST 'TRUE' PROPERTY Comp_SelectedKits REFRESHLIST 'TRUE' RETURN When there is more than one of the same Assembly# of course it moves both to the tselectedvalues table. I can use the COUNT command to see if there are more than one then an IF THEN statement. My question is, "How do I grab only one row since the list view only uses the var .Assyjob that relates to the Assembly# and both rows have the same assembly#?" James Belisle
