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:
- Right-click on your database connection and select New Data Manipulator to open the GridWorX data manipulator screen.
- 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.
- Click the ellipsis button and chose Browse Table for Delete to open the Select Table dialog box.
Creating a Data Manipulator
- 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