home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR16
/
DTSDDS.ZIP
/
DTSDDS.TPL
< prev
Wrap
Text File
|
1993-07-25
|
12KB
|
285 lines
#! *************************************************************************
#! DTSDDS.TPL This template has been generated as a temporary solution
#! for creating a DICTIONARY listing from the DCT file.
#! This is no manner intended to supersede the formal Clarion
#! Software solution for printing the DCT listing.
#!
#! Diversified Technology Solutions nor its principals nor
#! employees vow to the validity and operation of this
#! program.
#!
#! Distributed as FREEWARE you are responsible to taking
#! necessary precautions to protect your investment,
#! particularly CLA and/or DCT files.
#!
#! This product does not provide any means of error checking
#! to preclude overwriting any previously developed CLAs of
#! similar naming convention.
#!
#! Since this is NOT a formal product offering, it does NOT
#! include formal documentation. We STRONGLY suggest you
#! read the DTSDDS.DOC ASCII file included with this template
#! prior to using this template.
#!
#! Should you have any questions, we may be reached via
#! CompuServe-Clarion Software forum or E-Mail at
#! 76200,2531.
#!
#! *************************************************************************
#PROGRAM
#PROMPT('Program &Author',@S30),%Author
#! *************************************************************************
#PROCEDURE(DDSList,'Create a listing of the Data Dictionary')
#!╔════════════════════════════════════════════════════════════════════════
#!║ DATA DICTIONARY DOCUMENTATION TEMPLATE DDSDDS.TPL
#!║────────────────────────────────────────────────────────────────────────
#!║ Written by: Samuel W. Bellamy III
#!║ Diversified Technology Solutions
#!║ June 30, 1993
#!║─────────────────┬───────────┬──────────────────────────────────────────
#!║ Revision Dates: │ 930630 │Original Issue
#!║─────────────────┼───────────┼──────────────────────────────────────────
#!║ │ 930712 │ Added summarizing DDS listing.
#!║ │ │ Added MEMO information
#!║─────────────────┼───────────┼──────────────────────────────────────────
#!║ │ │
#!║ │ │
#!╚════════════════════════════════════════════════════════════════════════
!
! ╔════════════════════════════════════════════════════════════════════════
! ║ Data Dictionary Listing for: %DictionaryFile
! ║
! ║ Listing Name: %Program
! ║ Creation Date: %ProgramDateCreated %ProgramTimeCreated
! ║ Modified Date: %ProgramDateChanged %ProgramTimeChanged
! ║
! ╚════════════════════════════════════════════════════════════════════════
#PROMPT('&Methodlogy',OPTION),%DDSReportMethod
#PROMPT('Full',RADIO)
#PROMPT('Brief',RADIO)
#FIX(%FILE,%PRIMARY)
#IF(%DDSReportMethod='Full')
▄▄▄▄▄ DETAILED FILE DEFINITIONS ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
#FOR(%FILE)
▄▄▄▄ %FILE ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█ %FileDescription
█ Prefix: %FilePre Name: %FileName
█ Owner: %FileOwner Create: %FileCreate
█ Driver: %FileType %FileTypeParameter
█ Primary Key: %PrimaryKey
█
█ ╔══ FIELDS ═════════════════════════════════════════════════════════════
#FOR(%FIELD)
#IF(%FIELDTYPE <> 'Memo')
█ ║ ┌── Field: %FieldID is %FieldDescription
█ ║ │ Data Type: %FieldType (%FieldDisplayPicture)
#IF(%FieldPlaces)
█ ║ │ Decimal Places: %FieldPlaces
#ELSE
█ ║ │ Decimal Places: No decimal places defined.
#ENDIF
#IF(%FieldDimension1)
█ ║ │ Dimensions: One -%FieldDimension1 Two -%FieldDimension2
█ ║ │ Three-%FieldDimension3 Four-%FieldDimension4
#ELSE
█ ║ │ Dimensions: None
#ENDIF
#IF(%FieldHelp)
█ ║ │ Help ID: %FieldHelp
#ELSE
█ ║ │ Help ID: No help specified.
#ENDIF
#IF(%FieldRangeLow:Low)
█ ║ │ Range: %FieldRangeLow:Low %FieldRangeHigh:High
#ELSE
█ ║ │ Range: No data range specified.
#ENDIF
#IF(%FieldInitial)
█ ║ │ Initial Value: %FieldInitial
#ELSE
█ ║ │ Initial Value: No Initial Value specified.
#ENDIF
#IF(%FieldChoices)
█ ║ │ Choices: %FieldChoices
#ELSE
█ ║ │ Choices: No Choice options specified.
#ENDIF
#IF(%FieldLookup)
█ ║ │ Validation File: %FieldLookup
#ELSE
█ ║ │ Validation File: No Validation File specified.
#ENDIF
█ ║ └── END OF %FieldID IN %File ────────────────────────────────────────
#ELSE
█ ║ ┌── Field: %FieldID is %FieldDescription
█ ║ │ Data Type: %FieldType of %FieldMemoSize bytes in a %FieldMemoRows by %FieldMemoWidth
█ ║ │ Image: %FieldMemoImage
█ ║ └── END OF %FieldID IN %File ────────────────────────────────────────
#ENDIF
#ENDFOR
█ ╚══ END OF FIELDS ══════════════════════════════════════════════════════
█
█ ╔═ KEYS ═══════════════════════════════════════════════════════════════
#FOR(%KEY)
█ ║ ┌ Key: %Key
#FOR(%KEYFIELD)
█ ║ │ %KeyField %KeyFieldSequence
#ENDFOR
#IF(%KeyName)
█ ║ │ Name: %KeyName %KeyIndex
#ELSE
█ ║ │ Name: %Key
#ENDIF
#IF(%KeyAuto)
█ ║ │ Auto Incrementing?: %KeyAuto
#ELSE
█ ║ │ Auto Incrementing?: No Auto Incrementing Key specified.
#ENDIF
#IF(%KeyDuplicate)
█ ║ │ Allow Duplicates?: %KeyDuplicate
#ELSE
█ ║ │ Allow Duplicates?: No duplicate keys permitted.
#ENDIF
█ ║ └─ END OF %KEY IN %FILE ─────────────────────────────────────────────
#ENDFOR
█ ╚═ END OF KEYS IN %FILE ═══════════════════════════════════════════════
█
█ ╔═ RELATIONSHIPS IN %FILE ═════════════════════════════════════════════
#FOR(%RELATION)
█ ║ ┌── %FILE related to %Relation in a %RelationType
█ ║ │ Key: %RelationKey
#FOR(%RelationKeyField)
#IF(%RelationKeyFieldLink)
█ ║ │ %RelationKeyField links by %RelationKeyFieldLink
#ENDIF
#ENDFOR
#IF(%RelationConstraintDelete)
█ ║ │ Contraints Delete: %RelationConstraintDelete
#ELSE
█ ║ │ Contraints Delete: No Action
#ENDIF
#IF(%RelationConstraintUpdate)
█ ║ │ Update: %RelationConstraintUpdate
#ELSE
█ ║ │ Contraints Update: No Action
#ENDIF
█ ║ └─── End of %File for %Relation ───────────────────────────────────
#ENDFOR
█ ╚═══ END OF RELATIONSHIPS IN %FILE ════════════════════════════════════
█
▀▀▀▀▀ END OF %FILE DESCRIPTION ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
#ENDFOR
#ELSE
▄▄▄▄▄ SUMMARIZED FILE DEFINITIONS ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
#FOR(%FILE)
▄▄▄▄ %FILE ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█ %FileDescription
█ Prefix: %FilePre Name: %FileName
█ Driver: %FileType %FileTypeParameter
█
█ ╔══ FIELD ═══ TYPE ═════ PICTURE ══════════ DESCRIPTION ═══════════════
#FOR(%FIELD)
#IF(%FieldType <> 'MEMO')
█ ║ %FieldID │ %FieldType (%FieldDisplayPicture)│%FieldDescription
#ELSE
█ ║ %FieldID │%FieldType %FieldMemoSize bytes in %FieldMemoRows by %FieldMemoWidth for %FieldDescription
#ENDIF
#ENDFOR
█ ╚══ END OF FIELDs in %File ═════════════════════════════════════════════
█
█ ╔═ KEYS ═══ FIELD ══════════ SEQUENCE ═════════════════════════════════
#FOR(%KEY)
#FOR(%KEYFIELD)
█ ║────────────────────────────────────────────────────────────────────────
█ ║ %Key │ %KeyField │ %KeyFieldSequence │ %KeyIndex
#ENDFOR
#ENDFOR
█ ╚═ END OF KEYs IN %FILE ════════════════════════════════════════════════
█
█ ╔═ RELATIONSHIPS IN %FILE ══════════════════════════════════════════════
#FOR(%RELATION)
█ ║ ┌── %FILE related to %Relation in a %RelationType
█ ║ │ Key: %RelationKey
#FOR(%RelationKeyField)
#IF(%RelationKeyFieldLink)
█ ║ │ %RelationKeyField links by %RelationKeyFieldLink
#ENDIF
#ENDFOR
#IF(%RelationConstraintDelete)
█ ║ │ Contraints Delete: %RelationConstraintDelete
#ELSE
█ ║ │ Contraints Delete: No Action
#ENDIF
#IF(%RelationConstraintUpdate)
█ ║ │ Update: %RelationConstraintUpdate
#ELSE
█ ║ │ Contraints Update: No Action
#ENDIF
█ ║ └─── End of %File for %Relation ────────────────────────────────────
#ENDFOR
█ ╚═══ END OF RELATIONSHIPS IN %FILE ═════════════════════════════════════
█
▀▀▀▀▀ END OF %FILE DESCRIPTION ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
#ENDFOR
#ENDIF
#!╔═════════════════════════════════════════════════════════════════╗
#!║ These PROCEDUREs MUST be present for GENERATOR 930630 ║
#!╚═════════════════════════════════════════════════════════════════╝
#PROCEDURE(TODO,'Return immediately (for incomplete procedures)')
#!------------------------------------------------------------------------------
#!
#! The ToDo Template
#!
#! The Todo Template generates code for all procedures
#! which may be called, but which have not yet been designed.
#!
#! This template is reqired and must not be removed.
#!
#!------------------------------------------------------------------------------
%Procedure PROCEDURE
CODE
GLO:Message2 = CENTER('Procedure Undefined',45)
ShowWarning
RETURN #<!Return to caller
#!
#PROCEDURE(External,'Document external procedure call')
#!------------------------------------------------------------------------------
#!
#! The External Template
#!
#! This template allows the redefinition of a Todo procedure
#! for any external procedures which may be called.
#! This allows you to specify that this particular procedure
#! is not a Todo procedure and no Todo code will be generated.
#!
#! There is no source code for this procedure. See the template
#! help for more information.
#!
#!------------------------------------------------------------------------------
#!
#MODULE
#!------------------------------------------------------------------------------
#!
#! The Module Template
#!
#! The Module template generates the MEMBER statement, MAP structure, and
#! module global declarations for a source module of a Clarion program.
#! There is only one #MODULE segment in a template file chain.
#!
#!------------------------------------------------------------------------------
MEMBER('%Program')
OMIT('╝')
╔════════════════════════════════════════════════════════════════════════════╗
║ %Module - %ModuleDescription ║
╚════════════════════════════════════════════════════════════════════════════╝
%ModuleData
#EMBED('Data Section')