Joining Accpac Views Together Programmatically

[71001]

Hi,

Using C# dot net to retrieve data from accpac ERP system using the COMAPI objects. There is no problem retrieving these views individually AR0032 etc. Filtering and get a result set has been successful so far.

OpenView
FilterSelect
Browse...

Just wondering how to get information from two different views at the same time. View 1 is holding header information and View 2 holding detail information, i.e. AR0044 and AR0042. Is there a way to open one of these views - scroll to a row and automatically fetch the equivalent/matching row in the detail view. Get the result out quickly.

Just wondering if there is a way to join accpac views - like SQL base tables can be joined together.

Thanks

 

[Jay Converse]

No, you can't join views. Use ADODB instead.

 

[DjangMan]

A view is not a SQL view - it is an encapsulation of business logic and sometimes a table. Go wtih Tuba's suggestion - it'll be faster that way, too.

 

[Jay Converse]

Oooooo, encapsulation.... I love it when you talk dirty....