Delphi XAPI for Accpac Integration 2

[AlexJhb]

Is there an Accpac XAPI for Delphi?
There used to be one in the Accpac Version 5.0 SDK but I do not see one in the new SDK 5.5.
Any suggestions on how to integrate Dephi apps with Accpac?
i am new to development and somewhat new to Delphi. Have written an app in Delphi (Rad Studio 2007) now want to integrate it. Don't want to loose the 2 years I have put into this and besides, I love Delphi.

 

[ettienne]

You can certainly use the Accpac COM API, I'm not familiar with Delphi so I cannot give you examples, but there are other programmers using it.

 

[AlexJhb]

Hello Boet.
Looked in the 5.5 SDK but cannot find it. Expected it would be called XAPI according to the manual.
Do you know of anyone using it with Delphi that I could contact? A forum for example?

 

[ettienne]

Check on the Accpac forum, either the VBA forum or the DPP forum if you have access. There are certainly guys using Delphi on the DPP forum.

 

[DjangMan]

The SDK is all C and really, really dry. If you know C really well then you could convert the C headers into Delphi units and you'd be off to the races.

With my Delphi development/interfacing to Accpac I use the COMApi. I'm not creating any views so I'm not doing any SDK type development. It depends on your version of Delphi but you usually find the Import Component menu option and navigate to the a4wcomex.dll on your system and you'll get a Unit with new types for AccpacSession, AccpacView, etc.

From there you can so the same things that VBA macros and VB programs would do. I've not had much luck getting Accpac UI's to work in Delphi so I switch to VB6 for those. Anything I need to do real work with I do in Delphi. It runs faster and I have more tools/components to play with.

 

[AlexJhb]

Ettienne:
Will look at the DPP again.
DjangMan:
Using Delphi 2007. Not sure how to do all this but will try it out. Very sketchy on C++ but willing to learn.

Normally give serious stuff to my developer but this app is my baby done in Delphi and nobody else here uses it. So after 2 years want to see how it will work with Accpac and then maybe find a client for it.

Yes, I noticed Delphi is faster than the VB stuff the other guys do. I am wondering if the "New generation" (V6??) of Accpac will be able to use/integrate with Delphi. Have you heard anything? Believe it will be mostly Java.

 

[DjangMan]

What do you want to do with your application and Accpac? This will help us to figure out which is the best tool for the job.

 

[AlexJhb]

Sorry, been away training.
The app is a basic fleet management system. Would need to integrate with GL, IC and AP/AR at this stage. Can read stuff using ODBC but would prefer to use the API when writing to Accpac, like creating batches.

 

[DjangMan]

Do you need to add fields to existing tables or can you store your information in parallel tables? Do you need to post information to your tables while AR and AP are posting or can you do batch processing? IF you're just sending information back and forth then you can probably get away with the API. If you need to add fields to existing tables or need to intercept posting routines then the SDK is almost the only way to go.