8/17/2025 9:26:50 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
In Operator in Lookupedit control
Posted: 02 Sep 10 3:24 PM
|
I am using saleslogix version 7.5.2
On a lookupedit control how to use an "In" operator on a bunch of values..
For example...something like this
Sub AXFormCreate(Sender)
lkpA.LookupRestrictField = "Contact:Type"
lkpA.LookupRestrictOp = "In"
lkpA.LookupRestrictValue = "A , B"
End Sub
Thanks
|
|
|
|
Re: In Operator in Lookupedit control
Posted: 02 Sep 10 3:39 PM
|
Never mind found it...correct syntax is
Sub AXFormCreate(Sender)
lkpA.LookupRestrictField = "Contact:Type"
lkpA.LookupRestrictOp = "In"
lkpA.LookupRestrictValue = "('A' , 'B')"
End Sub |
|
|
|
Re: In Operator in Lookupedit control
Posted: 02 Sep 10 4:02 PM
|
I would use:
lkpA.LookupRestrictField = "Type"
lkpA.LookupRestrictOp = "IN ('A' , 'B') AND '1' = "
lkpA.LookupRestrictValue = "1"
but then I'm told I'm different....
SLX will construct this as
Select blah from CONTACT A1.....blah blah
WHERE TYPE IN ('A' , 'B') AND '1' = '1' "
and '1' actually does equal '1' |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|