teddybear
16th April 2012, 04:56
Hi,

I am trying to use the Exchange module to update the buyer code in table tdipu001 (Item Purchase Data). Generally, I have no issue with the updating but just trying to improve the process.

I noticed Exchange will create a log when the data that I am trying to update failed the DB reference check. Example, if the buyer code that I am trying to update is not created in the employee table yet.

However, Exchange does not return any error log when the key field, in my example will be the item code, is not found. Example, I am trying to update the buyer code for item ABC in table tdipu001 and item ABC is not exist in table tdipu001

Can anyone tell me how to enable this ?

Many thanks in advance.

frank holland
16th April 2012, 09:56
Hi,

One thing you could do, is make a boolean condition for updating a row.
This condition should deliver false whenever the item does not exist.

In the logs, you then see that a row was ignored because this condition applied.

Regards,
Frank