SQL Object
 
Syntax
 
SQL.SearchLedger([ResQuery][,MySearch])
 
Description
High-level function that greatly simplifies searching the account schema. If successful , the function returns a ledger account 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.
MySearch
Optional. Contains one or more search entries, separated by spaces. If not specified, the search window appears, as is also used in the Chart of Accounts application in Tradium.
 
See Also
other SQL.Searchxxxxxxxx functions, RekeningSchema.
Example
 
Sub Main
 
   Dim sZoek As String
 
   sZoek = InputBox$("Keywords:")
   If Len(sZoek) = 0 Then End
 
   Debug.Print SQL.SearchLeadger(, sZoek)
 
End Sub