Creation of Data Table change transaction.

“Data Table change” is the transaction types existed in agentry.

Here I am going to explain about these transaction types with simple examples.

Here my data table is: Shippers.

Data Table change: A data table change transaction is defined to allow the user to add or edit a data table record on the Agentry Client.

1. Editing data table records from agentry client:

Step 1: Add Object

• Add the “object” for the data table and add required properties to the object by considering back end table name and the columns.

• Set the key property.

Step 2: Add Transaction

• Go to transactions, add “Data table Change” transaction and give data table “Shippers”
  

• Add properties for the transaction.

• Set the key property.

Step 3: Add Server Update Step

• Add server update step, Go to steps add data table update step with group “Server Update”.

• Write update query to update the data table in back end from agentry client.

• Map this step to the transaction server update step.

          Go to Object–>transaction—>Server update tab.

Step 4: Design User Interface

• Go to Screen Sets, Add transaction Screen set.

• Add Platform.

• Add transaction detail screen.

Step 5: Add Actions & Buttons

• Go to “Actions” and add action to update data table.

• Add Action steps.

• Add Apply(save) step.

• Map Action to a screen button where you want. Here I am placing in “ShowCustomers” list screen.

• Publish definitions to agentry Dev server.

• Test Application in ATE.

     Inspect the existed data table entries in ATE.

     Go to—>Inspect—>Data Tables—>Shippers

• Update Data table entries. For key 18 I am updating value.

• Perform Xmit to update MSSQL back end table.

2. Adding Data table records form Agentry Client.

Step 1: Add transaction to add record into data table.

• Give the transaction properties.
  

• Write data table add step.

• Write the following Script.

• Map this step to add transaction update step.

• Define Add data table transaction screen set.

• Design the transaction screen as below:

Step 2: Add Action

• Go to action and add action.

• Add the following action steps

• Map this action any screen button. Here I am adding in “ShowCustomers” list screen.

• Publish definitions to agentry Dev server and test in ATE.
• Initially data table have following records.

• Now I am adding new record. Click on DT_Shipper_Add button.

• Check in ATE Data tables.

• Perform Xmit to Update back end table.

• Check in back end table.