![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » Elevate Web Builder Technical Support » Product Manuals » Elevate Web Builder 3 Manual » Using the Web Server » Web Server Database Access |
Command Type | Description |
Dataset | These commands execute SQL statements that perform row operations such as SELECT, INSERT, UPDATE, and DELETE DML statements. |
BLOB Column | These commands execute SQL statements that perform BLOB column operations such as SELECT and UPDATE DML statements, as well as retrieving the MIME content type of BLOB columns, and are named according to the BLOB column that is being operated on. This architecture optimizes BLOB column access performance and allows for the selective updating of BLOB columns. |
Command Name | Description |
Select | Contains an SQL statement that returns a result set. If the user cannot execute the Select command, then the dataset is effectively "invisible" to the user unless the dataset is being accessed in a server application.![]() |
Insert | Contains an SQL statement that inserts a new row into the dataset. If the user cannot execute the Insert command, then the user cannot insert any rows into the dataset unless the dataset is being updated in a server application.![]() |
Update | Contains an SQL statement that updates an existing row in the dataset. If the user cannot execute the Update command, then the user cannot update any rows in the dataset unless the rows are being updated in a server application.![]() |
Delete | Contains an SQL statement that deletes an existing row in the dataset. If the user cannot execute the Delete command, then the user cannot delete any rows in the dataset unless the rows are being deleted in a server application. |
Command Name | Description |
Select<Column Name> | Contains an SQL statement that returns a result set containing the specified BLOB column and, optionally, the MIME content type column for the BLOB column data, in a single row. If the user cannot execute the column command, then the user cannot read the BLOB column unless the BLOB column is being read in a server application. The MIME content type column is used by the web server to assign the Content-Type response header for any access to the BLOB column. The name of the MIME content type column should be set to <Column Name>_ContentType in order for the MIME content type column to be used correctly by the database access in the web server.![]() |
Update<Column Name> | Contains an SQL statement that updates the specified BLOB column in an existing row in the dataset.![]() |
Update<Column Name>_ContentType | Contains an SQL statement that updates the MIME content type for the specified BLOB column in an existing row. This content type is used by the web server to assign the Content-Type response header for any access to the BLOB column.![]() |
Operation | Description |
Get DataSet Columns | This operation executes the Select dataset command (without any input parameters) and returns the columns for the dataset. |
Get DataSet Parameters | This operation executes the Select dataset command (without any input parameters) and returns the parameters for the command. |
Get DataSet Rows | This operation executes the Select dataset command and returns the rows for the dataset. |
Get DataSet BLOB Column | This operation executes the Select<Column Name> dataset command and returns the data in the specified BLOB column along with an optional <Column Name>_ContentType column that specifies the MIME content type for the BLOB column data. |
Commit Transaction | This operation commits a transaction that was previously started automatically or manually by the client or server application. Each transaction contains a series of row inserts, updates, and deletes that are executed in the order in which they occurred using the Insert, Update, Update<Column Name>, and Delete commands. For server applications, a transaction commit will update any BLOB columns that were modified after each insert or update.![]() |
This web page was last updated on Friday, January 31, 2025 at 08:42 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |