The first routine brings back a comma separated list of values as expected, but the second doesn’t find the values.
The first brings back numbers, where the second brings back a list of names (strings)
With oDB
strSQL = "SELECT line FROM AllocationOnLine WHERE Allocation = " & Allocation.ToString
.dbQuerySQL(strSQL, dt)
End With
Dim lineString As String = ""
For Each dr As DataRow In dt.Rows
lineString &= dr.Item(1).ToString & ", "
Next
allDisgorgeLines = lineString.Substring(0, lineString.Length - 2)
'Get a list of all the Makes included in the specified Allocation
With oDB
strSQL = "SELECT make FROM Allocations a "
strSQL += "INNER JOIN AllocationOnLine ao ON a.Allocatio ...
Go to the complete details ...