Follow-On Topics

Related Topics

# About the Memory Tab

The Memory tab of the ODBC Memory dialog box is displayed when either the Add or Edit button is selected in the Memory Definitions dialog box or the ODBC Memory option is selected in the Please select a Memory Provider dialog box. The dialog box is used to configure an ODBC Memory Definition through the following:
|  | Name — A name for the Memory Definition may be manually entered. This initially displays ODBC Memory but this may then be edited as required.
|  | ODBC Data Source — Displays a list of available ODBC data sources for selection.
|  | Table — Clicking on the Browse button opens the Select Table dialog box that displays the available tables for the selected ODBC data source. Selecting a table and clicking OK then displays the table name in the Tables field. Click the image to view full size.
| Click the image to view full size.

|  | Columns — Displays a list of the columns available in the selected table, for which data is to be memorised. Objects may be mapped against specific columns by dragging and dropping them from the Task Browser dialog box into the value field for each column. The table displays details for each column under the following headings:

|  | Name — Displays the name of the column.

|  | Value — Displays the object value for mapped objects or Not mapped where no object has been mapped.

|  | Key — This check box enables the column to be selected as a key column in the ODBC memory data set.

|  | Clear — Removes the selected column from the table.

|  | Edit SQL — Displays the SQL script that has been automatically created for the ODBC memory. The dialog box changes to SQL Free Type Mode which allows the user to manually edit the SQL statements depending on the radio button selected at the bottom of the dialog box. Items may also be dragged and dropped into the edit box from the Task Browser dialog box. Click the image to view full size.

|  | Record Lookup — The `SELECT` statement is displayed in the edit box for editing.

|  | Record Update — The `UPDATE` statement is displayed in the edit box for editing.

|  | Record Insert — The `INSERT` statement is displayed in the edit box for editing.

|  | Test — Allows the current selected statement to be tested by executing it. Where vales are required for specific columns that have been mapped, the Enter Values dialog box is displayed. Click the image to view full size.

Clicking on a row displays the Enter Value dialog box to enable the user to manually enter a value. Testing `UPDATE` and `INSERT` statements can potentially amend the database, which may be rolled back using transactions. Where the connection doesn't support transactions then a confirmation dialog box is displayed to inform the user that testing the statement results in changes being made to the database.

Copyright © 2018 Quadrant Software B.V. All rights reserved.