DataControl.SQLQuery

From Xojo Documentation

Revision as of 18:19, 16 January 2012 by Dbrandt (talk | contribs)

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"