Hello group,
I've been banging my head against the wall all day on this one. Does
anybody out there have an example of how to use a search adapter in a
Vantage 8.03.403 customization? Specifically, I am trying to load up a
data set to determine if an employee is currently clocked in. I
thought something like this would work to get the recordset (which I'd
go on to use in my logic to determine if they are clocked in):
Dim labor As LaborAdapter = New LaborAdapter(MESMenu)
labor.BOConnect()
Dim MorePages As Boolean
Dim opts As SearchOptions = New SearchOptions(SearchMode.AutoSearch)
opts.NamedSearch.WhereClauses.Add("EmployeeNum", "1234")
opts.NamedSearch.WhereClauses.Add("ActiveTrans", "yes")
Dim results As Data.DataSet = labor.GetRows(opts, MorePages)
labor.Dispose()
...but it keeps hanging up. Am I using those WhereClauses correctly?
Thanks,
Adam
I've been banging my head against the wall all day on this one. Does
anybody out there have an example of how to use a search adapter in a
Vantage 8.03.403 customization? Specifically, I am trying to load up a
data set to determine if an employee is currently clocked in. I
thought something like this would work to get the recordset (which I'd
go on to use in my logic to determine if they are clocked in):
Dim labor As LaborAdapter = New LaborAdapter(MESMenu)
labor.BOConnect()
Dim MorePages As Boolean
Dim opts As SearchOptions = New SearchOptions(SearchMode.AutoSearch)
opts.NamedSearch.WhereClauses.Add("EmployeeNum", "1234")
opts.NamedSearch.WhereClauses.Add("ActiveTrans", "yes")
Dim results As Data.DataSet = labor.GetRows(opts, MorePages)
labor.Dispose()
...but it keeps hanging up. Am I using those WhereClauses correctly?
Thanks,
Adam