SQL Object

DisplayQuickView

 
Syntax
 
SQL.DisplayQuickView Query[, Caption][, Header][, Footer]
 
Description
Displays small floating window, showing the output of a query, including optional header and footer. The list features auto-link to applications and data-driven colouring as well (sqligent).
 
Parameter
Description
Query
The sql SELECT-query to be executed
Caption
Optional. Displays text in the form's header.
Header
Optional. Displays text above the list view.
Footer
Optional. Displays text below the list view.
 
See Also
DisplayPercentage, DisplayStatus.
Example
Sub Main()
 
    Dim Query As String, sHead As String, sFoot As String
 
    Query = "SELECT * FROM usr_PlaatsAfstanden"
    sHead = "Overzicht bekende plaatsen en hun afstanden"
    sFoot = "Gemiddelde afstand: " & SQL.RunQueryGet1Field("SELECT AVG(Afstand) FROM usr_PlaatsAfstanden")
 
    SQL.DisplayQuickView Query, "Informatie", sHead, sFoot
 
End Sub