SQL Object

SearchMultipleProducts

 
Syntax
 
SQL.SearchMultipleProducts(items(), text()[, ExcludeDeleted][, ExtraFilter])
 
Description
High-level feature that greatly simplifies searching the item file. It allows multiple articles to be selected at the same time, including numbers. If successful, the function returns the number of different articles in a long integer (Long).
 
This function is optimized for retrieving complex search queries; Its search power is comparable to that of well-known search engines on the Internet. For an explanation of the search capabilities, see the explanation in the general guide.
 
Parameter
Description
items()
Array variable of type Single. Must be dimensioned beforehand and contains per element the entered number of the selected item.
Text()
Array variable of type String. Must be dimensioned in advance and contains the selected item number for each element.
ExcludeDeleted
Optional, default value FALSE. If TRUE, items marked as inactive are filtered out of the result.
ExtraFilter
Optional. A SQL WHERE clause can be specified here,
for example: "ArtikelStam.Groep NOT IN 'VERPAK', 'KOSTEN')"
 
See Also
other SQL.Searchxxxxxxxx functions, Product Management.
Example
Sub Main()
 
    Dim i() As Single, t() As String
    Dim x As Integer, z As Long
 
    ReDim i(9999) As Single, t(9999) As String
 
    z = SQL.SearchMutlipleProducts(i(), t(), True)
 
    For x = 0 To z
        Debug.Print x
        Debug.Print i(x)
        Debug.Print t(x)
        Debug.Print String$(80, "=")
    Next
 
    Stop   ' lees de waarden uit in het debug-venster
 
End Sub