Thanks a lot. I will give it a go. Dan Goldberg
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, November 17, 2016 4:39 PM To: [email protected] Subject: RE: [RBASE-L] - variable lookup list mult select groups Dan, I set up 2 variables in the on before start eep SET VAR vCodeList NOTE = NULL SET VAR vCodeListTXT NOTE = NULL The info I'm trying to capture are TEXT variables The variable for the var list view is vCodeList In my dbl clk eep in the var list view SET VAR vQuotes = (CVAL('QUOTES')) SET VAR vCodeListTXT NOTE = NULL SET VAR vRows = (ITEMCNT(.vCodeList)) SET VAR vCodeListTXT = ('('+.vCodeList+')') SET VAR vMode = 'Edit' SET VAR vnupc TEXT = EquipUPC, + vequipsd DATE = EquipEnterDate, + vequipdd DATE = EquipDueDate + IN Equipment WHERE EquipUPC IN &vCodeListTXT IF vaccesslevel < 6 THEN BROWSE USING Equipment WHERE EquipUPC IN &vCodeListTXT ELSE EDIT USING Equipment WHERE EquipUPC IN &vCodeListTXT ENDIF SET VAR vTransUPC = NULL SET VAR vSearchFor = NULL RECALC VARIABLES PROPERTY ContinueButton ENABLED 'FALSE' PROPERTY SearchFor SET_FOCUS 'TRUE' RETURN I hope this gives you something to try. I didn't clean any of it up. Jan -----Original Message----- From: Dan Goldberg <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Fri, 18 Nov 2016 00:32:34 +0000 Subject: RE: [RBASE-L] - variable lookup list mult select groups I am also using that list to check against integer values in a table. Browse all from tablename where serial in (.vlist) If I run it with vlist as a text it comes up with a random column must be compared to integer values. But if I run Browse all from tablename where serial in(‘1’,’2’,’3’,’7’,’9’) it works fine. Strange. Dan Goldberg From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, November 17, 2016 4:10 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - variable lookup list mult select groups Hmmm. Let me fire up the program and look at my settings. -----Original Message----- From: Dan Goldberg <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thu, 17 Nov 2016 23:55:06 +0000 Subject: RE: [RBASE-L] - variable lookup list mult select groups Thx Jan. I have the multi select on and the variable is text. I am guessing the variable must be a different type for it to work. Dan Goldberg From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, November 17, 2016 3:52 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - variable lookup list mult select groups There is a way. You have to enable "multi-select" in the list view. Be aware that you will to change the variable that you use to capture the "multi". Not in front of R:Base right now and can't tell you where it is, but I have done it before and it works great! -----Original Message----- From: Dan Goldberg <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thu, 17 Nov 2016 23:49:18 +0000 Subject: [RBASE-L] - variable lookup list mult select groups Is there a way to select a group of items in a variable lookup list other than clicking on one at a time? It would be nice to be able to select the first one and then hold down the shift on the last one I need to select a range but cannot find a setting for it. TIA Dan Goldberg -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
