SearchProduct

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