SQL Object
 
Syntax
 
SQL.SearchProduct([ResQuery][, ExcludeDeleted][, ExtraFilter])
 
Description
High-level function that greatly simplifies searching the article file. If successful, the function returns an article number 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
ResQuery
Optional. Returns the Select query built in this function.
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
 
      Debug.Print SQL.SearchProduct()
 
End Sub