Go to the bottom.

! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: QFVALUE.SDDL ! ! Purpose: This SDDL file defines the qfvalue relation. ! ! Modification History: ! ! Date OPR Who Reason ! -------- ------- --- ------------------------------------------------- ! 11/ 7/94 27329 EGB Original implementation ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE FORTRAN, SQL RECORD QFVAL_TYPE !------------------------------------------------------------------------------ ! ! RECORD INFORMATION ! !------------------------------------------------------------------------------ DESCRIPTION "This relation defines the possible values for the SPSS Smartstar form fields and is used during run-time to drive validation of user input data." !------------------------------------------------------------------------------ ! ! 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 with qfosmartstar, not for any automatically generated queries." RELATED_FIELDS "qfosmartstar.rl_name" END_FIELD FIELD rl_fldnam 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 with qfosmartstar, not for any automatically generated queries." RELATED_FIELDS "qfosmartstar.rl_fld" END_FIELD FIELD check_flag TYPE C2 DESCRIPTION "This field controls what kind of processing will occur after field data has been entered. There are many different settings for this field: RI = range inclusive i.e. x <= DATA <= y RE = range exclusive i.e. x < DATA < y RL = range lower i.e. x < DATA <= y RU = range upper i.e. x <= DATA < y D = discrete i.e. DATA = 'Y', 'N', ' ' T1 = time format: yyyy.DDD T2 = time format: yyyy.DDD:HH:MM:SS T3 = day duration format: (+,-)(dd)dd:hh:mm:ss T4 = unsigned day durration format:(dd)dd:hh:mm:ss E = equinox/epoch HR = time format ((h)hh:mm:ss) N = no check required DR = time duration check format (+,-)(hh)hh:mm:ss DZ = unsigned time dur check format (hh)hh:mm:ss Programmer's note: See SPSS routine qabuar.for to see how these checks are made in the software." END_FIELD FIELD format_fld TYPE C2 DESCRIPTION "This field is a tri-state flag describing the format of the data to be entered: I = Integer R = Real C = Character (or string) " END_FIELD FIELD put_flag TYPE C1 DESCRIPTION "When this field is 'D', then there is a default value that should be displayed when the form is entered or cleared. When the field is 'S', it is a key field and there may be carryover data from another form, or it may be displayed as a blank area. Carryover data is key field data that will remain intact from form to form based on user inputs. For example, if you enter a proposal id on a form then switch to another form with a proposal id field, that value you entered will appear there also." DISCRETE "S", "D" END_FIELD FIELD discrete TYPE C8 DESCRIPTION "If the qfosmartstar.check_flag is 'D', this field will contain a single possible discrete value. When a field has multiple discrete values there must be one entry in this table for each." END_FIELD FIELD min_char TYPE C20 DESCRIPTION "If the qfosmartstar.check_flag is 'R%', then this field will have range checking done on it. This field contains the lower or minimum range value." END_FIELD FIELD max_char TYPE C20 DESCRIPTION "If the qfosmartstar.check_flag is 'R%', then this field will have range checking done on it. This field contains the upper or maximum range value." END_FIELD FIELD char_def TYPE C20 DESCRIPTION "The data in this field is the default displayed value as will be displayed if the qfosmartstar.put_flag is set at 'D' and the datatype is character." END_FIELD FIELD min_numeric TYPE C24 DESCRIPTION "If the qfosmartstar.check_flag is 'R%', then this field will have range checking done on it. This field contains the lower or minimum range value and is a numeric value (integer or real)." END_FIELD FIELD max_numeric TYPE C24 DESCRIPTION "If the qfosmartstar.check_flag is 'R%', then this field will have range checking done on it. This field contains the upper or maximum range value and is a numeric value (integer or real)." END_FIELD FIELD num_def TYPE C24 DESCRIPTION "The data in this field is the default displayed value as will be displayed if the qfosmartstar.put_flag is set at 'D' and the datatype is numeric (integer or real)." END_FIELD END_RECORD !------------------------------------------------------------------------------ ! ! RELATION DECLARATION ! !------------------------------------------------------------------------------ RELATION qfvalue TYPE QFVAL_TYPE DESCRIPTION "SPSS Smartstar Form Field Value Description Relation" SUBSYSTEM_USING "SPSS" RELATED_FIELDS "qfosmartstar.*" INDEX qfvalue_1 TYPE unique, clustered FIELDS rl_name, rl_fldnam, discrete END_INDEX END_RELATION !------------------------------------------------------------------------------ ! ! INSTANCE DECLARATION ! !------------------------------------------------------------------------------ INSTANCE qfvalue GLOBAL TYPE QFVAL_TYPE END_INSTANCE

Go to the top.