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.

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