Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QFOSMARTSTAR.SDDL
!
! Purpose:      This SDDL file defines the qfosmartstar relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/ 7/94    27329     EGB   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE	FORTRAN, SQL

RECORD  QFO_TYPE

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

    DESCRIPTION       "This relation defines a mapping of the SPSS Smartstar
		       form fields to the PMDB database relations and their 
		       fields.  This is used to map into the sibling table
		       qfvalue that contains field specific value information."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------


    FIELD  rl_name
        TYPE            C12
        DESCRIPTION     "This field contains the name of the relation with 
			 which the Smartstar form is associated.  When 
			 the relation is more than 12 characters, this will
			 be an abbreviated name. This data is used to join into 
			 qfvalue, not for any automatically generated queries."
        RELATED_FIELDS  "qfvalue.rl_name"
    END_FIELD


    FIELD  rl_fld
        TYPE            C12
        DESCRIPTION     "This field contains the name of a field within a 
			 relation to which a Smartstar form field is mapped.
			 When the database field names exceed 12 characters an
			 abbreviated name must be used.  This data is used to 
			 join into qfvalue, not for any automatically 
			 generated queries."
        RELATED_FIELDS  "qfvalue.rl_fldnam"
    END_FIELD


    FIELD  form_name
        TYPE            C9
        DESCRIPTION     "This field holds the name of the Smartstar form.  See 
			 help on SPSS PFORM or IFORM commands for a list of 
			 legal values."
    END_FIELD


    FIELD  field_name
        TYPE            C7
        DESCRIPTION     "This field maps the database entry here to the true 
			 Smartstar field name as assigned via the SDESIGN 
			 form product.  The field naming convention is FLD__##
			 where ## = 01, 02, 99.  "
    END_FIELD


    FIELD  assoc_fld
        TYPE            C7
        DESCRIPTION     "This is an obsolete field."
    END_FIELD


    FIELD  action_flg
        TYPE            C1
        DESCRIPTION     "This field is a two way flag that indicates if the 
			 data associated with the form field is display only or
                         user entered. 'S' means it is software calculated 
			 display only data.  'U' means the field can be modified
			 by the user."
	DISCRETE        "S", "U"
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------


RELATION  qfosmartstar

    TYPE             QFO_TYPE

    DESCRIPTION      "SPSS Smartstar Form Field to Database Mapping Relation"

    SUBSYSTEM_USING  "SPSS"

    RELATED_FIELDS  "qfvalue.*"

    INDEX  qfosmartstar_1
        TYPE         unique, clustered
        FIELDS       form_name, rl_name, rl_fld, field_name
        ATTRIBUTES   ignore_dup_key
    END_INDEX

    INDEX  qfosmartstar_2
        TYPE         unique, nonclustered
        FIELDS       form_name, field_name
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------

INSTANCE  qfosmartstar

    GLOBAL

    TYPE        QFO_TYPE

END_INSTANCE

Go to the top.