Mike
Moderator
Dear Team,
Is any one can tell me this below is .df:-
I want to know here what do you mean by order 20 /30 here marked red .Please explain me:-
Sample .df of the 'Monitor' table:
ADD TABLE "Monitor"
AREA "Schema Area"
DUMP-NAME "monitor"
ADD FIELD "cTableName" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 2
SQL-WIDTH 16
ORDER 10
ADD FIELD "cFieldName" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 3
SQL-WIDTH 16
ORDER 20
ADD FIELD "cUserId" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 4
SQL-WIDTH 16
ORDER 30
ADD FIELD "rOldRecid" OF "Monitor" AS recid
FORMAT ">>>>>>9"
INITIAL ?
POSITION 5
SQL-WIDTH 4
ORDER 40<<<<<<<<
ADD FIELD "rNewRecId" OF "Monitor" AS recid
FORMAT ">>>>>>9"
INITIAL ?
POSITION 6
SQL-WIDTH 4
ORDER 50 <<<<
ADD FIELD "cOldStringValue" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 7
SQL-WIDTH 16
ORDER 60 <<<<<<<<<<<<<<<
ADD FIELD "cNewStringValue" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 8
SQL-WIDTH 16
ORDER 70
ADD FIELD "cTime" OF "Monitor" AS character
FORMAT "HH:MM:SS"
INITIAL ""
POSITION 9
SQL-WIDTH 16
ORDER 80
ADD FIELD "cDate" OF "Monitor" AS date
FORMAT "99/99/9999"
INITIAL ?
POSITION 10
SQL-WIDTH 4
ORDER 90
ADD FIELD "Deal" OF "ATC" AS character
DESCRIPTION "Deal Code"
FORMAT "x(3)"
INITIAL ""
LABEL "Deal"
POSITION 3
MAX-WIDTH 3
COLUMN-LABEL "Deal"
HELP "Deal Code"
ORDER 20 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<,,
ADD FIELD "Coast" OF "ATC" AS character
DESCRIPTION "Coast code"
FORMAT "x(1)"
INITIAL ""
LABEL "Coast"
POSITION 4
MAX-WIDTH 1
COLUMN-LABEL "Coast!Code"
HELP "Coast Code. Leave blank for both coasts"
ORDER 30 <<<<<<<<<<<<<<<<<<<
with Regards
Shane
Is any one can tell me this below is .df:-
I want to know here what do you mean by order 20 /30 here marked red .Please explain me:-
Sample .df of the 'Monitor' table:
ADD TABLE "Monitor"
AREA "Schema Area"
DUMP-NAME "monitor"
ADD FIELD "cTableName" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 2
SQL-WIDTH 16
ORDER 10
ADD FIELD "cFieldName" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 3
SQL-WIDTH 16
ORDER 20
ADD FIELD "cUserId" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 4
SQL-WIDTH 16
ORDER 30
ADD FIELD "rOldRecid" OF "Monitor" AS recid
FORMAT ">>>>>>9"
INITIAL ?
POSITION 5
SQL-WIDTH 4
ORDER 40<<<<<<<<
ADD FIELD "rNewRecId" OF "Monitor" AS recid
FORMAT ">>>>>>9"
INITIAL ?
POSITION 6
SQL-WIDTH 4
ORDER 50 <<<<
ADD FIELD "cOldStringValue" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 7
SQL-WIDTH 16
ORDER 60 <<<<<<<<<<<<<<<
ADD FIELD "cNewStringValue" OF "Monitor" AS character
FORMAT "X(8)"
INITIAL ""
POSITION 8
SQL-WIDTH 16
ORDER 70
ADD FIELD "cTime" OF "Monitor" AS character
FORMAT "HH:MM:SS"
INITIAL ""
POSITION 9
SQL-WIDTH 16
ORDER 80
ADD FIELD "cDate" OF "Monitor" AS date
FORMAT "99/99/9999"
INITIAL ?
POSITION 10
SQL-WIDTH 4
ORDER 90
ADD FIELD "Deal" OF "ATC" AS character
DESCRIPTION "Deal Code"
FORMAT "x(3)"
INITIAL ""
LABEL "Deal"
POSITION 3
MAX-WIDTH 3
COLUMN-LABEL "Deal"
HELP "Deal Code"
ORDER 20 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<,,
ADD FIELD "Coast" OF "ATC" AS character
DESCRIPTION "Coast code"
FORMAT "x(1)"
INITIAL ""
LABEL "Coast"
POSITION 4
MAX-WIDTH 1
COLUMN-LABEL "Coast!Code"
HELP "Coast Code. Leave blank for both coasts"
ORDER 30 <<<<<<<<<<<<<<<<<<<
with Regards
Shane