SQL Object

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