PxPlus User Forum

Twitter Twitter Twitter

Author Topic: index object idxinfo.pvc  (Read 280 times)

Peter.Higgins

  • Gold Member
  • ****
  • Posts: 67
    • View Profile
index object idxinfo.pvc
« on: December 24, 2019, 04:53:36 PM »
Can anyone tell me if the null suppression on the last segment for a Primary internal key is in anyway related to the K: or N: attributes in the index object? 

 ! IF POS("N"=COLUMNATTR$) THEN IDXINFO'COLUMNATTR$="N",IDXINFO'COLUMNNULLCHARACTER$=MID(COLUMNATTR$,POS("N;"=COLUMNATTR$)+2,2),BuildColumnAttr$+="N"
 ! IF POS("K"=COLUMNATTR$) THEN IDXINFO'NULLSUPPRESS=1,IDXINFO'NULLCHARACTER$=MID(COLUMNATTR$,POS("K;"=COLUMNATTR$)+2,2),BuildAttr$+="K"