Updating Vendors Table

[Bluejay07]

Hello,

I have two sets of code which are virtually identical for AR and AP.

Within the code, I am checking if the customer/vendor exists to determine if I need to perform a .insert or a .update.

The code works perfectly fine with AR, however, I receive the following error when AP tries the .update.

"Record has been modified by another program."

I do not have any problems with the .insert, only with the .update.

Any suggestions on why this could be occuring?

Thanks.

 

[ettienne]

This normally happens if you do not .Read the record before .Update

 

[Bluejay07]

Thanks for the reply ettienne.

I will try using a .read before the update.

 

[ettienne]

Remember to do the .Read first, then put your changes and then .Update - if you .Read after you put then your changes will be lost.