Export data from Sage 50 CA using SDK

SOLVED

Hi all,

Is there anyone has an idea to export the data from Sage 50 CA? I was looking at the method w the class "CustomerLedger" but it has only the Save method it does not have the get method, Please let me know if you have any idea of hints to solve the issue.

Thanks

SF

Parents
  • 0
    SUGGESTED

    I don't use the SDK myself but looking at the docs, there is one routine called wSDBExecSelectSQL that I believe can take any SELECT SQL statement.  This should give you the ability to pull what data you want and then you can use whatever program you are working on to handle the data after that.

    In the SDK help under the SimplySKD.Support namespace you will find Runxxx methods.  This may help you as well.  Transaction processing is available here as well if you not just doing SELECT statetments.

Reply
  • 0
    SUGGESTED

    I don't use the SDK myself but looking at the docs, there is one routine called wSDBExecSelectSQL that I believe can take any SELECT SQL statement.  This should give you the ability to pull what data you want and then you can use whatever program you are working on to handle the data after that.

    In the SDK help under the SimplySKD.Support namespace you will find Runxxx methods.  This may help you as well.  Transaction processing is available here as well if you not just doing SELECT statetments.

Children