RunDataEditor

Syntax

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

Description

Opens a VIEW, TABLE or a SELECT query, and presents the data in a window that can be browsed. If the user has permissions to do so, the data can also be edited.

The output is similar to the output option: "Data worksheet" 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, Data-werkblad.

Example

Sub Main()
 
    Dim sQuery As String
 
    sQuery = InputBox$("Select Query:")
    SQL.RunDataEditor sQuery, "Mijn Query", "Mijn Layout"
 
End Sub