SearchCustomer

Syntax

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

Description

High-level function that greatly simplifies searching the customer database. If successful , the function returns one or more customer 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 capabilities, 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 clients via optionbox control in the search window.
MySearch	Optional. Contains one or more search data separated by spaces. If not specified, the customer search window, as is also used in the Customers application in Tradium.
ExcludeDeleted	Optional, default value FALSE. If TRUE, customers marked as inactive are filtered out of the result.

See Also

other SQL.Searchxxxxxxxx functions, Customers.

Example

Sub Main

Dim sZoek As String

sZoek = InputBox$("Keywords:")

Debug.Print SQL.SearchCustomer(, , sZoek)

End Sub