Sample Oracle connection entry
This example illustrates an Oracle connection entry named Customer.
(*
* Entry: Customer
* SQL Table: CUSTOMER
*
*)
DEFINE_ENTRY
NAME Customer
MODEL_DOC_STATEMENT WITH
DATA_RETRIEVAL "from CUSTOMER where CUSTOMERNUMBER=:1"
KEY_RETRIEVAL "from CUSTOMER where (CUSTOMERNUMBER>=:1)"
DEFINE_PARAMETERS
Customernumber NUMERICAL ( 9 0) DATABASE_FIELD "CUSTOMERNUMBER"
END_DEFINE_PARAMETERS
DEFINE_FIELDS
Customernumber NUMERICAL ( 9 0) DATABASE_FIELD "CUSTOMERNUMBER"
Surname C_CHAR (31 ) DATABASE_FIELD "SURNAME" SCREEN_FIELD 1
Firstname C_CHAR (31 ) DATABASE_FIELD "FIRSTNAME"
Initials C_CHAR (11 ) DATABASE_FIELD "INITIALS"
Dateofbirth NUMERICAL (11 0) DATABASE_FIELD "(to_char(DATEOFBIRTH, 'YYYYMMDD'))"
Dateofdeath NUMERICAL (11 0) DATABASE_FIELD "(to_char(DATEOFDEATH, 'YYYYMMDD'))"
Gender C_CHAR ( 2 ) DATABASE_FIELD "GENDER"
Maritalstate C_CHAR ( 2 ) DATABASE_FIELD "MARITALSTATE"
Partnernumber NUMERICAL ( 9 0) DATABASE_FIELD "PARTNERNUMBER"
END_DEFINE_FIELDS
DEFINE_SUBENTRIES
(* Place subentry definitions here *)
END_DEFINE_SUBENTRIES
END_DEFINE_ENTRY (* Customer *)