Agentry development - can't update sql database

[Former Member]

Hi experts,

I am learning agentry development and now just develop sql-base sample based on Northiwind.

I made update screen but it doesn't work.

The data I enter on ATE client does not update sql database table.

(It's seems update sql is not executed by client)

How should I debug during development.

Could you give me some clue to resolve?

Thanks

Even I change some customer data No sending message are shown on the transmit dialog.

below is setting I did

1) Transaction definition and its update step

2) Action and its step

3) Step definition and its sql

[former_member224650 · Accepted solution]

Hello , did you apply as in the action below?

[Former Member · Accepted solution]

Rikardt,

In the section 2, in the first image you can see there is an apply on the action he is calling.

Takayoshi,

If you use the ATE, you can open "Inspect" -> "Transactions" to see the values entered in the transaction you are creating to make sure you are seeing the expected values.

Stephen

[Former Member · Accepted solution]

Hi Steve,

Thank you for your reply.

I can see the customer data I entered in ATE from menu "Inspect->Transactions" like below.

I think these data should be transferred and update database when pushing "Xmit" button.

Is this true?

There is a question.

Thought I select  menu from "Test -> Remove Transactions", No data is removed.

Is this a normal or not?

Thanks

[Former Member · Accepted solution]

By doing "Test -> Remove Transactions" it should of cleared all the transaction show in that list.

I would recommend clearing closing the ATE, and clearing it out and test again.   To clear the client go into the folder and everything expect any .exe, .sst. or .dll.

Stephen Streeter

[Former Member · Accepted solution]

Hi Stephen,

Thank you for giving me a good advice.

ATE works fine and "Test -> Remove Transactions" is available.

What I did is very simple as below

1) Uninstall ATE

2) Delete ATE folder

3) Install ATE

If you know more smart way to clean ATE, Let me know.

Thanks and Regards

[Former Member]

Your transmit window does not show a transaction.  On the client did you follow thru the action and edit the customer data?