PxPlus User Forum
Main Board => Discussions => Programming => Topic started by: Peter.Higgins 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"