DataControl.SQLQuery

From Xojo Documentation

Revision as of 21:20, 25 October 2018 by PLefebvre (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Property (As String )
aDataControl.SQLQuery = newStringValue
or
StringValue = aDataControl.SQLQuery

Supported for all project types and targets.

The SQL query used to obtain the default RecordSet. You can enter the default SQL query into the Properties pane.

Example

This example gets all the rows from the “Movies” table in the database.

Me.Database = database
Me.SQLQuery = "SELECT * FROM Movies"