Skip to Content

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

      
     /wp-content/uploads/2014/04/object_431797.jpg

  • Set the key property.

/wp-content/uploads/2014/04/key_431879.jpg

Step 2: Add Transaction

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

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Add properties for the transaction.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Set the key property.

        /wp-content/uploads/2014/04/trans_432003.jpg

Step 3: Add Server Update Step

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

   /wp-content/uploads/2014/04/trans_432003.jpg

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

/wp-content/uploads/2014/04/trans_432003.jpg

  • Map this step to the transaction server update step.

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

     /wp-content/uploads/2014/04/trans_432003.jpg

Step 4: Design User Interface


  • Go to Screen Sets, Add transaction Screen set.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Add Platform.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Add transaction detail screen.

     /wp-content/uploads/2014/04/trans_432003.jpg

Step 5: Add Actions & Buttons


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

  /wp-content/uploads/2014/04/trans_432003.jpg

  • Add Action steps.

      /wp-content/uploads/2014/04/trans_432003.jpg

  • Add Apply(save) step.

    

     /wp-content/uploads/2014/04/trans_432003.jpg

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

     

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Publish definitions to agentry Dev server.

    

         /wp-content/uploads/2014/04/trans_432003.jpg

  • Test Application in ATE.

     Inspect the existed data table entries in ATE.

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

     /wp-content/uploads/2014/04/trans_432003.jpg

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

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Perform Xmit to update MSSQL back end table.

/wp-content/uploads/2014/04/trans_432003.jpg

2. Adding Data table records form Agentry Client.


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

/wp-content/uploads/2014/04/trans_432003.jpg

  • Give the transaction properties.

/wp-content/uploads/2014/04/trans_432003.jpg

  • Write data table add step.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Write the following Script.

      /wp-content/uploads/2014/04/trans_432003.jpg

  • Map this step to add transaction update step.

/wp-content/uploads/2014/04/trans_432003.jpg

  • Define Add data table transaction screen set.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Design the transaction screen as below:

      /wp-content/uploads/2014/04/trans_432003.jpg

Step 2: Add Action

  • Go to action and add action.

    

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Add the following action steps

     /wp-content/uploads/2014/04/trans_432003.jpg

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

     /wp-content/uploads/2014/04/trans_432003.jpg

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

     /wp-content/uploads/2014/04/trans_432003.jpg

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

    

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Check in ATE Data tables.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Perform Xmit to Update back end table.

     /wp-content/uploads/2014/04/trans_432003.jpg

  • Check in back end table.

          /wp-content/uploads/2014/04/trans_432003.jpg

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply