COMAPI View .Order

[iwells]

What are the values/options for using the .order properties of a declared view?

mDBLinkCmpRW.OpenView "IC0280", vICHIST
vICHIST.Order = ?

If I wanted to sort by ITEMNO? DAYENDSEQ?

How would I do that? Are the valid numbers (in this case 0 to 5) the keys in order that they appear in the object model for that view?

 

[Jay Converse]

You can only choose the 6 that are pre-defined, you can't add indexes on the fly.

 

[ettienne]

Use CS0120 and "select * from ICHIST order by ITEMNO"

Sage 300 Certified Consultant

 

[iwells]

Tuba: are the 6 that are predefined the ones that appear in the header section of each table/view in the Sage object model? Foe examnple for ICHIST they are:

Account Set Code ACCTSET, LOCATION, ITEMNO, FISCYEAR, FISCPERIOD, TRANSDATE, DAYENDSEQ, ENTRYSEQ, LINENO
Item Number D ITEMNO, ACCTSET, LOCATION, FISCYEAR, FISCPERIOD
Location D LOCATION, ACCTSET, ITEMNO, FISCYEAR, FISCPERIOD
Dayend Sequence D M DAYENDSEQ, ENTRYSEQ, LINENO
Item Number/Location D M ITEMNO, LOCATION, FISCYEAR, FISCPERIOD
Document Number D M DOCNUM, ITEMNO, LOCATION, TRANSTYPE

 

[Jay Converse]

Yes