SearchSupplier

Syntax

SQL.SearchSupplier([ResQuery][,Marklist][,MySearch][, ExcludeDeleted])

Description

High-level function that greatly simplifies searching the supplier file. If successful , the function returns one or more supplier numbers in a string.

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 options, see the explanation in the general guide.

Parameter	Description
ResQuery	Optional. Returns the Select query built in this function.
Marklist	Optional. Yes/No parameter. If TRUE, user can highlight multiple vendors via optionbox control in search window.
MySearch	Optional. Contains one or more search data separated by spaces. If not specified, the supplier search window, as is also used in the Suppliers application in Tradium.
ExcludeDeleted	Optional, default value FALSE. If TRUE, vendors marked as inactive are filtered out of the result.

See Also

other SQL.Searchxxxxxxxx functions, leveranciers.

Example

Sub Main()
 
    Dim sZoek As String
 
    sZoek = InputBox$("Trefwoorden:")
    Debug.Print SQL.SearchSupplier(, , sZoek)
 
End Sub