StatementType
Overview
The StatementType enumeration denotes how the given Schema statement will be translated to a SQL database request.
Location
- Reference: RemObjects.DataAbstract.dll
- Namespace: RemObjects.DataAbstract.Schema
| Value | Description |
|---|---|
| AutoSQL | SQL query will be composed on the fly using Schema table field names, datatypes, mapping information etc. This is the most commonly used Schema statement type. |
| Join | Reserved |
| SQL | Schema Statement already contains a statical SQL query. This statement type allows to manually compose and store in the Schema SQL statement that will be used to access the underlying database table. Statements of type SQL can be used when data table access requeres some parameters to be set or when SQL query that accesses the database should be fine-tuned (f.e. some databases allow to set index names that should be used by the given SQL query) |
| StoredProcedure | Schema Statement contains stored procedure name that should be executed when a Schema table is accessed (or a Schema command is executed) |