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
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.


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

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