The Records is not in editable state

Question

Hi, 
 I got this "The Records is not in editable state" Error while delete contact from Ar_CustomerContact_bus object. 
 Please anyone give hint to solve this issue. 
 
 Thanks.

49153 · Accepted Answer

Hint: summit's wrong in your code.

Steve Passmore · Answer

When you have a record loaded in the business object as you do, simply invoking the Delete method with no argument should work. I tried doing a delete with the business object as you are doing and it worked for me. 
 
The Delete method also will accept an argument of the specific key to delete. With the multi-part key of AR_CustomerContact it would require you to pad out each key segment to the defined length of the field, concatenating the three fields into a single string value to use as that argument. For multi-part key tables it is easier to do what you are doing. 
 
If the Delete method is returning success but the record is still in the table, I'm at a loss to explain that...

Kent Mackall · Answer

Greetings, 
 
Any COM compliant language may be used to interact with the Sage 100 Business Objects. 
 
On current Sage 100 versions, there is no license or cost associated with using the Business Object Interface. We did require a license on older versions (I think this was prior to the 5.10 release) . 
 
If you plan on working with the Business Object Interface, we strongly encourage you to take the Sage 100 Business Object Interface training class available from Sage Learning Services. Most of our examples use VBS with a few .NET and C# examples. 
 
Lastly, if you are not familiar with the table structure of Sage 100 you should consider taking the Program and Data Files classes prior to the Object Interface training. 
 
Thank you, 
Kent

Sage 100

The Records is not in editable state

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING