Documentation

Chapter 28. db1util

Table of Contents

addsysfield()
Description
Prototype
Parameters
addsysfieldext()
Description
Prototype
Parameters
addsystable()
Description
Prototype
Parameters
blobtotext()
Description
Prototype
Parameters
compareeqdb1recs()
Description
Prototype
Parameters
copy_db1rec_to_db1rec()
Description
Prototype
Parameters
copy_db1rec_to_db1table()
Description
Prototype
Parameters
copyextendedinfo()
Description
Prototype
Parameters
create_sbme1table_from_db1table()
Description
Prototype
Parameters
createdefaultsystemtableentries()
Description
Prototype
Parameters
createextendedtableinfo()
Description
Prototype
Parameters
createsysfields()
Description
Prototype
Parameters
createsysfieldsext()
Description
Prototype
Parameters
createsystables()
Description
Prototype
Parameters
createsystablesysteminexistingsbm()
Description
Prototype
Parameters
deleteallrecordsfromtable()
Description
Prototype
Parameters
fieldval2string()
Description
Prototype
Parameters
getdefaultdisplayformat()
Description
Prototype
Parameters
getdefaultformat()
Description
Prototype
Parameters
getfield()
Description
Prototype
Parameters
getfieldextid()
Description
Prototype
Parameters
getfieldid()
Description
Prototype
Parameters
getfieldinfoarray()
Description
Prototype
Parameters
getfieldscount()
Description
Prototype
Parameters
getfieldsextcount()
Description
Prototype
Parameters
getindex()
Description
Prototype
Parameters
getsysserial()
Description
Prototype
Parameters
getsystemtable()
Description
Prototype
Parameters
gettableid()
Description
Prototype
Parameters
gettablename()
Description
Prototype
Parameters
gettableparent()
Description
Prototype
Parameters
getuniqueindex()
Description
Prototype
Parameters
getuniquenindex()
Description
Prototype
Parameters
isdb1field()
Description
Prototype
Parameters
isdb1table()
Description
Prototype
Parameters
isfield()
Description
Prototype
Parameters
isindex()
Description
Prototype
Parameters
islocked()
Description
Prototype
Parameters
lockrecord()
Description
Prototype
Parameters
outputdb1record()
Description
Prototype
Parameters
paddedhex()
Description
Prototype
Parameters
removetablefromsystemtables()
Description
Prototype
Parameters
string2fieldval()
Description
Prototype
Parameters
string2val()
Description
Prototype
Parameters
tableexists()
Description
Prototype
Parameters
unlockrecord()
Description
Prototype
Parameters
updateextfieldinfo()
Description
Prototype
Parameters
updatesysfield()
Description
Prototype
Parameters
updatesysfieldext()
Description
Prototype
Parameters
val2string()
Description
Prototype
Parameters

The db1util library is the primary collection of helpful functions for working with databases in SIMPOL. The db1util name comes from the type tag names that are associated with the single-user SBME component and the multi-user PPCS component. These functions are key components used throughout the data-aware environment and are also used in numerous support libraries.

addsysfield()

Description

Prototype

addsysfield ( type(db1table) fieldstable, integer tableid, string fieldname, string fieldtype, boolean indexed, string help, string comment, integer error )

Parameters

ParameterDefault valueType nameDescription
fieldstableNonetype(db1table)
tableidNoneinteger
fieldnameNonestring
fieldtypeNonestring
indexed.falseboolean
helpNonestring
commentNonestring
errorNoneinteger