RunDataList

Syntax

SQL.RunDataList ViewOrTableOrQuery[, AlternativeTitle][, LayoutString]

Description

Opens a VIEW, TABLE or a SELECT query, and presents the data in a window that can be browsed. The data is read-only and cannot be modified.

The output is similar to the output option: "Data list" in the SQL Designer

Parameter	Description
ViewOrTableOrQuery	A reference to a View, Table or Select query.
AlternativeTitle	Optional, display of title in application tab
LayoutString	Optional, name for storage personal column settings When populated, AlternativeTitle should also be populated

See Also

other SQL.Runxxxxxxxx methodes, Datalijst.

Example

Sub Main()
 
    Dim sQuery As String
 
    sQuery = InputBox$("Select Query:")
    SQL.RunDataList sQuery
 
End Sub