SearchProject

Syntax

SQL.SearchProject([ResQuery][, MySearch][, ExcludeHistory])

Description

High-level function that greatly simplifies project searching. If successful , the function returns a project numbers 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.
MySearch	Optional. Contains one or more search data, separated by spaces. If not specified, the search window appears, as is also used in the Projects application in Tradium.
ExcludeHistory	Optional. If TRUE, projects with status 'H' (historical) are filtered out of the search result. CAUTION: Also, when searching directly for a project number while this filter is active, this function returns 0 if the project is historical.

See Also

other SQL.Searchxxxxxxxx functions, Projects.

Example

Sub Main()
 
    Dim sZoek As String
 
    sZoek = InputBox$("Trefwoorden:")
    If Len(sZoek) = 0 Then End
 
    Debug.Print SQL.SearchProject(, sZoek)
 
End Sub