OpenView COM API (Can a View be sorted)

[71001]

Hi,

Using the accpac COMAPI SDK 5.5A - to retrieve data programmatically from accpac ERP 5.5. Programmatically using OpenView function.

I was wondering if there a way to sort the contents of a VIEW other than by its key fields? i.e. I want to find the minimum date retreived from a view (without scrolling through each record)... Is this possible with the COMAPI/Views?

If anyone has any information that would help that would be great!

Regards

Diana

 

[Jay Converse]

No.

 

[71001]

Any other ideas?

 

[Jay Converse]

Use ADO and a regular SELECT statement.