Creating a Data Manipulator in GridWorX

Data Manipulator objects in GridWorX manipulate database data and structure using stored procedures or simple SQL statements when your database server or engine does not support stored procedures. Data manipulation actions are executed only on a per-request basis.

To Create a Data Manipulator:

1. Right-click on your database connection and select New Data Manipulator to open the GridWorX data manipulator screen.
2. Give a descriptive name to the data manipulator. For example, you might want to create a Data Manipulator which you can set to delete records from the Product Table.
3. Click the ellipsis button and chose Browse Table for Delete to open the Select Table dialog box.

Creating a Data Manipulator

4. Select the table to be affected by this Data Manipulator. For example, to delete a record from the Products table, select Products in this dialog box.

Select Table Screen

5. Click OK to create the Data Manipulator.

Data Manipulator Screen

See also:

Connecting to Open Databases

Creating a Data Source

Creating a Data Item

Advanced SQL Designer

GridWorX Introduction