James, I'm not sure that LIMIT = 1 will always return the first row in a table. As Dennis mentioned you will need someway to differentiate your 2 different rows.
Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 26 May 2011 17:13:26 -0500 Subject: [RBASE-L] - RE: VARLISTVIEW Dennis, I tried it using this APPEND JobOrder2 TO tSelectedValues WHERE Assembly# = .vAssyjob AND LIMIT=1 PROPERTY Comp_Assy REFRESHLIST 'TRUE' PROPERTY Comp_SelectedKits REFRESHLIST 'TRUE' RETURN There were two rows in the joborder2 table with the assembly# SBU-SA4. One had a quantity of 26, the other had a quantity of 40. In the joborder2 table where I am pulling this information from, the 40 was entered first then the 26. In the listview, Even though I clicked on the row with qty of 26, it took the one with 40 to the tSelectedValues table. Is it true then that the LIMIT=1 gets the first row entered into any table (just like last gets the last one)? James Belisle From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, May 26, 2011 4:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: VARLISTVIEW 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
