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]>
To: "[email protected]" <[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]] On Behalf
Ofjan johansen
Sent: Thursday, November 17, 2016 4:10 PM
To: [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] [mailto:[email protected]]] On
Behalf Ofjan 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
[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
[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
[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
[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
[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.
