Example output (ODBC Entry Wizard)

(*
    * Entry:                Customer
    * SQL Table:            Customer
    * Creation date:        19 april 1999
    *)
   DEFINE_ENTRY
      NAME                     "Customer"
      MODEL_DOC_STATEMENT      WITH
      PROGRAM_DATA_RETRIEVAL   "from Customer where CustomerNumber=:1"
      PROGRAM_KEY_RETRIEVAL    "from Customer where (CustomerNumber>=:1)"
      
DEFINE_PARAMETERS
         Customernumber                   NUMERICAL   (  13 0)   DATABASE_FIELD   "CustomerNumber"
      END_DEFINE_PARAMETERS
      DEFINE_FIELDS
         Customernumber                   NUMERICAL   (  13 0)   DATABASE_FIELD   "CustomerNumber"
         Firstname                        C_CHAR      (  31  )   DATABASE_FIELD   "FirstName"
         Initials                         C_CHAR      (  11  )   DATABASE_FIELD   "Initials"
         Dateofbirth                      NUMERICAL   (  11 0)   DATABASE_FIELD   "({fn year(DateOfBirth)}*10000 + {fn month(DateOfBirth)}*100 + {fn dayofmonth(DateOfBirth)})"
         Dateofdeath                      NUMERICAL   (  11 0)   DATABASE_FIELD   "({fn year(DateOfDeath)}*10000 + {fn month(DateOfDeath)}*100 + {fn dayofmonth(DateOfDeath)})"
         Gender                           C_CHAR      (   2  )   DATABASE_FIELD   "Gender"
         Maritalstate                     C_CHAR      (   2  )   DATABASE_FIELD   "MaritalState"
         Partnernumber                    NUMERICAL   (  13 0)   DATABASE_FIELD   "PartnerNumber"
      END_DEFINE_FIELDS
      DEFINE_SUBENTRIES
         (* Place Sub-Entry Definitions here *)
      END_DEFINE_SUBENTRIES
   END_DEFINE_ENTRY   (* Customer *)