DataControl.SQLQuery
From Xojo Documentation
Property (As String )
aDataControl.SQLQuery = newStringValue
or
StringValue = aDataControl.SQLQuery
Supported for all project types and targets.
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.