Is AS0020 (aka ASORGS, Companies) available in a SQL Server table?

[JonathanCampbell]

I am attempting to obtain the company list.

Is it available in a SQL Server table in the system database, or only accessible through SDK access (session.Organizations)?

I'm using ACCPAC V6.0a. The doc appears to imply that it is only available in the DLL, does not list a SQL table.

Thanks
Jon

 

[ettienne]

No, it is not in an SQL table.
You can open the AS0020 view and browse the records though.

 

[JonathanCampbell]

Thanks very much, Ettienne, that was my plan if I couldn't find it elsewhere.

Any particular reason it wasn't instantiated in the external system DB? Sage's other
multi-company ERPs (MAS90/200, MAS500) have SQL Server company tables.

Thanks again
Jon

 

[Jay Converse]

For database independence.

 

[ettienne]

Company information is stored in the ORGS.ISM file in the Site folder - this is a database independent ISAM file. As tuba says it is for database independance - Accpac at one stage supported 4 different databases.

 

[JonathanCampbell]

OK, thanks. It makes things a bit inconvenient, but doable.

Thanks again
Jon

 

[ettienne]

If you need the data in SQL then browse AS0020 and write the data to an optional field. I do this for users where I need user names on a report/query.

 

[JonathanCampbell]

Yes, thanks again.

Jon

 

[DjangMan]

Another way is to .Init a Session and then access the Organizations. You can do this all through COM without needing the SDK. You don't have to .Open a Session before getting access to the Organizations.

 

[JonathanCampbell]

Thanks, DjangMan,

Thanks very much. Actually, that's exactly what we have done.

Thanks again
Jon

 

[JonathanCampbell]

Does anyone know how to use the ACCPAC SDK to get the contents of a view object directly, in bulk, into a C# DataTable, not just a cell or row at a time? Fetch and BLKCPY appear to get only one row at a time, no matter what you do.

Thanks
Jon

 

[Jay Converse]

You have to use a loop.

 

[JonathanCampbell]

Thanks, tuba2007, that's what I had surmised.

Thanks again,
Jon