Database Service Functions

This Chapter consists the descriptions of all functions in the modules dmi, dbi and mdb.


Module dmi

dal_dmi_cre_men create menu in local memory
dal_dmi_cre_but create button area in local memory
dal_dmi_cre_lis create list in local memory
dal_dmi_cre_frm create form in local memory
dal_dmi_set_dis Set Database Select to use DISTINCT
dal_dmi_set_cft_siz set fetchblock
dal_dmi_ret_cft_siz return fetchblock size
dal_dmi_set_cmn_alg set menu generating mechanism
dal_dmi_ret_cmn_alg return menu generating mechanism


Module dbi

dal_dbi_res_ran re-initialize random number generator
dal_dbi_dal_loa_tab update table definition in local memory
dal_dbi_dal_loa_ent update entity definition in local memory
dal_dbi_dal_loa_rel update relation definition in local memory
dal_dbi_dal_loa_typ update type definition in local memory
dal_dbi_dal_loa_cns update constraint definition in local memory
dal_dbi_get_mes read message text for message name
dal_dbi_ret_max_idn return record Id in table
dal_dbi_get_usr_dat return user data for user name
dal_dbi_get_grp_dat return group data for group name
dal_dbi_get_usr_nam return user name for UIC
dal_dbi_get_grp_nam return group name for GIC
dal_dbi_get_grp_lis return group data for UIC
dal_dbi_get_dal_lng_lis return language entries from T_LANGUAGE
dal_dbi_get_acc_elm return access data for record Id
dal_dbi_get_tab_ent return entity Id for table name
dal_dbi_get_ent_idn return entity Id for entity name
dal_dbi_get_rel_idn return relation Id for entity Ids and view liefern
dal_dbi_get_typ_idn return type Id for entity Id and for type name
dal_dbi_get_ent_dat return mask and table name for entity Id
dal_dbi_get_ref_dat return mask and table name for refine Id
dal_dbi_get_agg_dat return mask and table name for aggregate Id
dal_dbi_get_typ_dat return mask and table name for type Id
dal_dbi_get_ent_lis return names and Ids of all entities
dal_dbi_get_ent_ref return names and Ids of all refine relation objects
dal_dbi_get_ent_agg return names and Ids of all aggregate relation objects
dal_dbi_get_ent_typ return names and Ids of all types for parent entity
dal_dbi_get_elm_typ return names and Ids of all types for parent element
dal_dbi_get_tab_inf return table type and entity- or relation Id for table name
dal_dbi_get_dal_mas_inf return mask type, connected table names and entity Ids for default mask name
dal_dbi_get_dal_mas_men return widget menu name for mask name
dal_dbi_get_siz_fld return field length from table-field assignment
dal_dbi_cre_aut create authorization entry for record
dal_dbi_upd_aut update edit date for record
dal_dbi_lck_elm create or check lock entry for record
dal_dbi_set_fre toggle lock release on or off
dal_dbi_fre_lck remove lock entries for records
dal_dbi_get_lck return initiating user for the lock entry
dal_dbi_rel_lck control locking of inserted relations
dal_dbi_del_elm delete record with internal references
dal_dbi_del_lis delete several records with internal references
dal_dbi_ren_elm re-enumerate Ids in original and relation tables
dal_dbi_chk_elm check record existence in table
dal_dbi_set_del set reference check flag
dal_dbi_chk_ref check record for number of refine relations
dal_dbi_chk_agg check record for number of aggregate relations
dal_dbi_unl_tab delete table entry from local memory
dal_dbi_unl_ent delete entity entry from local memory
dal_dbi_unl_rel delete relation entry from local memory
dal_dbi_unl_typ delete type entry from local memory
dal_dbi_unl_cns delete constraint entry from local memory
dal_dbi_mod_ent change entity entry in local memory
dal_dbi_mod_rel change relation entry in local memory
dal_dbi_mod_typ change type entry in local memory
dal_dbi_mod_cns return constraint entry in local memory
dal_dbi_get_ent_nam return entity name for entity Id
dal_dbi_get_rel_nam return relation name (view) for relation Id
dal_dbi_get_typ_nam return type name for type Id
dal_dbi_get_cns_idn return constraint Id for constraint name
dal_dbi_get_cns_nam return constraint name for constraint Id
dal_dbi_get_blb return content of a BLOB-field
dal_dbi_put_blb update content of a BLOB-field
dal_dbi_get_ltx return content of a Longtext field
dal_dbi_chk_vie check if object is a view


Module mdb

dal_mdb_cre_tab create table in data base
dal_mdb_del_tab delete table from data base