Creation of Data Table change transaction.

[former_member197782]

"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.