Language Reference Guide : System Classes : SQLSelect Class
 
Share this page          
SQLSelect Class
The SQLSelect class represents the SQL statement contained in a DataStream object.
You can use SQLSelect objects to create ad hoc queries or to modify generated queries dynamically. Because the SQLSelect object is based exclusively on SQL text and syntax, any valid SQL query can be placed into an SQLSelect object.
Note:  Gateway-specific extensions that are not OpenSQL are also valid in SQLSelects (in the Query attribute).
SQLSelect objects interact dynamically with the database, verifying that the names and data types of the columns in its target list are the same as those coded when the application was designed.
For a detailed discussion of using SQLSelects in 4GL code, see the Programming Guide.
Inherits From
Object Class
DataStream Class
Inherited By
ColumnCross
CrossTable
QueryObject
RowCross
Attributes
DBSession
Query
QueryName
Methods
None