Follow-On Topics

Related Topics

# About the Memory Tab

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

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

|  | Edit SQL — Displays the SQL script that has been automatically created for the OLEDB 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 will be displayed in the edit box for editing.

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

|  | Record Insert — The `INSERT` statement will be 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 will be displayed. Click the image to view full size.

Clicking on a row display the Enter Value dialog box to enable the user to manually enter a value. Testing `UPDATE` and `INSERT` statements will 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 will result in changes being made to the database.

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