User Tools

Site Tools


prop_fieldsfile.htm
Navigation:  Language Reference > App C - PROP: Runtime Properties > Runtime VIEW and FILE Properties >====== PROP:FieldsFile ====== Previous pageReturn to chapter overviewNext page

Property of a VIEW which returns a reference to the file that contains the specified field number in a VIEW. (READ ONLY)

Example:

Header  FILE,DRIVER('TopSpeed'),PRE(Hea)

OrderKey KEY(Hea:AcctNumber, Hea:OrderNumber)

Record   RECORD

AcctNumber  LONG

OrderNumber  LONG

OrderDate   LONG

    . .

Detail  FILE,DRIVER('TopSpeed'),PRE(Det)

OrderKey KEY(Det:AcctNumber,Det:OrderNumber)

Record   RECORD

AcctNumber  LONG

OrderNumber  LONG

ItemNumber  LONG

    . .

AView   VIEW(Header)        

    PROJECT(Hea:AcctNumber,Hea:OrderNumber,Hea:OrderDate)

     JOIN(Det:OrderKey,Hea:AcctNumber,Hea:OrderNumber)

    . .

!AView{PROP:Field,1} Returns 1 which represents Hea:AcctNumber

!AView{PROP:Field,2} Returns 2 which represents Hea:OrderNumber

!AView{PROP:Field,3} Returns 3 which represents Hea:OrderDate

!AView{PROP:Field,4} Returns 1 which represents Det:AcctNumber

!AView{PROP:Field,5} Returns 2 which represents Det:OrderNumber

!AView{PROP:Field,6} Returns 3 which represents Det:ItemNumber

!AView{PROP:FieldsFile,2} Returns a reference to the Header File

!AView{PROP:FieldsFile,5} Returns a reference to the Detail File

prop_fieldsfile.htm.txt · Last modified: 2021/04/15 15:57 (external edit)