Stephen Smith's Blog

Musings on Machine Learning…

Opening Sage 300 ERP Sessions » objectmodel

with 3 comments

3 Responses

Subscribe to comments with RSS.

  1. Hi Stephen, this post might not be at the correct blog entry but I have a question that we have been struggling with for a while. is there something in the COM API through vb6 that will allow me to see if a certain transaction is open on a UI screen already?

    The reason I ask is this: we have an integration layer that post various Accpac transactions through the COM API using vb6. we also push throuch Technisoft service manager document entries using the same methods and captured macro.

    with some Accpac functions and also with service manager jobs we run into the issue that a user might have a window with a record loaded in UI. when we then try to integrate something to that same transaction for example a service manager job, we end up corrupting the job or Accpac transction.

    we need a way through vb6 to determine if a certain transaction is loaded in a certain module and accpac company, so that if it is, our integration layer can ignore it and move on.
    thank you very much and hoping for a reply.


    January 18, 2016 at 10:45 pm

    • You can only do this if the particular transaction puts a lock on the record or a semaphor associated with the record. This is why only one person can edit an invoice at a time. Generally we use optimistic concurrency so there isn’t any locking to check on. However this shouldn’t ever result in database corruption, at worse you should get a record modified by another user error when you try to save.


      January 19, 2016 at 2:37 am

      • thank you for the quick replay Stephen.


        January 19, 2016 at 6:25 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.