jdeuser2001
Active Member
Hello group,
I am trying to set selection in an application to return a data set using a '*' wildcard character in one of the criteria of my data select.
Is this possible?
If not, how can a search be done on a portion of a string?
Here is my code:
VA evt_RelatedLOT = concat(substr([VA evt_Lot],0,12),'*')
Set Selection(FC Grid, "F46L11", "ITM", <Equal To>, VA evt_IdentifierShortItem, <And>)
Set Selection(FC Grid, F46L11, "LOTN", <Equal To>, VA evt_RelatedLOT, <And>)
Set Selection(FC Grid, "F46L11", "MMEJ", <Equal To>, VA evt_Date, <And>)
The value in the VA evt_RelatedLOT = '174X90137273*'
Thanks all!
Will.
I am trying to set selection in an application to return a data set using a '*' wildcard character in one of the criteria of my data select.
Is this possible?
If not, how can a search be done on a portion of a string?
Here is my code:
VA evt_RelatedLOT = concat(substr([VA evt_Lot],0,12),'*')
Set Selection(FC Grid, "F46L11", "ITM", <Equal To>, VA evt_IdentifierShortItem, <And>)
Set Selection(FC Grid, F46L11, "LOTN", <Equal To>, VA evt_RelatedLOT, <And>)
Set Selection(FC Grid, "F46L11", "MMEJ", <Equal To>, VA evt_Date, <And>)
The value in the VA evt_RelatedLOT = '174X90137273*'
Thanks all!
Will.