ACCPAC Plus

ACCPAC Database API

Snipped from the R&D Team Blog

Accpac Database API Accpac is a three tier application with the business logic separated from the database. The business logic objects (the real core of the Accounting Applications) communicate with the database via a common database API. Then there are database drivers that translate this API into calls to the database server currently being used. How the database driver accomplishes this is entirely up to the driver. The SQL Server driver uses ODBC to communicate with the SQL Sever Native driver. Oracle uses the Oracle ODBC driver. Pervasive communicates with both the relational layer using SQL calls, and with the transactional layer making direct Pervasive API calls. The key point is that all this detail is invisible to the Business Logic. The application programmer creating the business logic objects, just needs to know the Accpac database API to do his job. Then all the differences in the databases are isolated to the Accpac database driver. If a new version of a database server is released and Accpac needs to be updated to support it, then its just a matter of providing a new database driver, without requiring any other application changes. The Accpac database API includes a number of record oriented API calls, a number of meta-data calls and a number of set based operations. The record based APIs operate on one record at a time, such as read a record based on a supplied key, update that record. The meta-data calls return information about the structure of the database, things like get a list of all the tables in the database, get information on all the fields in a table. The set oriented API calls operate on a set of records at a time. Such as read all records where the description starts with A, or update all records changing any with customer number 1200 to 1400, or delete all records with status “deleted”.

ACCPAC Plus in full screen mode

Yup, this is for all of you still relying on good old faithul ACCPAC Plus for DOS. You might have noticed that when your hardware or OS was upgraded, and you reinstalled ACCPAC Plus, that suddenly it was running in a window and if you pressed alt-enter to make it full screen, it was all funky colours and only filled half the now full screen DOS box. Well, never fear. Although you seriously need to consider upgrading to Sage ERP Accpac, some of you have some quite sound reasons as to why you cannot or will not upgrade. This then, is for you:

1. Run ACCPAC Plus

Double-click the shortcut to start ACCPAC Plus.

2. Select the window’s colour properties page

Right-click on the window title bar to get the pop-up menu. Choose the Properties entry and then the Colors tab. Note the line of 16 colours in the middle of the dialog box. You are going to change these. Continue reading

HashFlare

Blogroll

Member of The Internet Defense League