Jim, You are doing a select from joborder2. With the limit, you append only on row instead of many.
What are you clicking? If you are clicking on a list, retrieve the primary key and use that to select what to insert, instead of the Assembly# If you don't have a primary key on JobOrder2, it will need one in this case. 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 4:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: VARLISTVIEW Dennis, Will the limit always take just the row I click? I was considering that but did not know if that meant the first row in a series of rows or just the one you click. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, May 26, 2011 4:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: VARLISTVIEW 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
