Promotic

Object PmaDatabase (Database)

Description:
This object represents one database table. By means of this object the data from the table can be read and the data can be event written to it.
This object is obsolete (but functional) and it is better to use the PmaAdo object.

No other Pma objects can be created in this object.
This object can be created in objects: PmaRoot, PmaFolder, PmaPrototype. Multiple objects of this type can be created in such objects.
The usage of the PmaDatabase object requires purchase of the "PmDB" licence. When developing the application in the freeware mode PmFree, or with development environment and while testing it in runtime, this component is always functional.

It isn't required to install the database system on the computer with PROMOTIC installed on it. PROMOTIC installs full database support for all operation (reading, writing, table creating, ...) itself.

The PmaDatabase object can be handled in two ways:
1. handling with the object referring to an existent table.
2. handling with the object referring to a nonexistent table.
This object inherits properties, methods and events of the PmaObject object.
Properties and methods of this object:
AddBegin of the edit mode for adding a row
AddNewAdds an empty row
BeginTransBegin of transaction
CancelUpdateEnd of the edit mode, changes canceling
CloseClosing the database table and the database
CloseTableClosing the table (the database remains open)
CommitConfirmation of the transaction
CompactDatabaseDefragmentation of the Access database
ConnectConnection of the database to the application
CreateBegin of the creation table mode
CreateEndEnd of the creation table mode
CreateFieldCreates the column in the table structure
CreateIndexCreates the index over the column of the database table
DatabasePath and name of a database file
DeleteDeletes the record on the current position in the database table
DeleteTableDeletes the database table
EditBegin of the edit mode
ExecuteExecute the statement in the SQL language syntax
ExecuteSQLExecute the statement in the SQL language syntax
ExistTableTest for the occurrence of the table in the database
FindFirstSearch for the text string in the database table from beginning of the table
FindLastSearch for the string in the database table from the end of the table
FindNextSearch for the string in the table from the current position forward
FindPrevSearch for the string in the table from the current position backward
GetArrayCreates an array or matrix of values read from selected table columns
GetFieldCountReturns the number of columns in the database table
GetFieldInfoReturns the information about columns in the database table
GetRecordCountReturns the rough number of rows in the table
IsBOFTest whether the current pointer position is at the beginning of the database table
IsConnectTest whether the database is connected
IsEOFTest whether the current pointer position is at the end of the database table
IsOpenTest whether the database table is opened
MoveMove the current position by the specified number of records
MoveFirstMove the current position to the beginning of the database table
MoveLastMove the current position to the end of the database table
MoveNextMove the current position by one record forward in the table
MovePrevMove the current position by one record backward in the table
MoveToMove the current position to the specified record in the table
OpenOpen the database table
OpenSQLSQL statement of the SELECT type type on open
PasswordPassword for an access to databases/tables
ReadFieldValueReturns a value of the column in the current row
RequeryRe-reading the content of the table
RollBackRollback of the transaction processing of the table
SetLockingModeSets the row locking mode
SetNullValueSets the "Null" value
SetParamSets parameters of the PmaDatabase object
SetRecordValueNullWriting the "Null" value into the item
SetRecordValuesNullWriting the "Null" value into the whole record
TableTable name
TypeDatabase type
UpdateEnd of the edit mode, writing changes
UserUser name
WriteFieldValueSets the value of the column in the current row
Obsolete properties and methods:
FieldValuesValue of the column in the current row
Properties and methods inherited from the PmaObject object:
AddEventRegisters a function into selected event
GetInfoReturns the Info object with the specified name
GetOwnedByIndexReturns the subobject defined by its index
GetOwnedByNameReturns reference to the subobject defined by its name
GetOwnedByTypeArray of references to the subobjects
GetOwnedNumReturns number of subobjects in the object
GetParReading the value of the Pma object parameter (or its parents)
GetPathNameObject name with the path to this object
GetPermissionReturns permission of corresponding operation from object
MethodsAccess to designer's methods of this object
NameObject name (without the path)
ParentReturns reference to the parent Pma object
PmReturns reference to the Pma object or to its implementation subobject
RemoveEventUnregisters the function in the specified event
RootReturns reference to the root application object PmaRoot
Events inherited from the PmaObject object:
onStartIs triggered for each object in the runtime only once at the beginning
onStopIs triggered for each Pma object in runtime only once at the stop of the application
Configuration tabs:
ObjectGeneral information about the object
EventsDefinition of object events algorithms
DatabaseSetting the parameters for the work with the database table

History:
Pm9.00.00: Object name changed: PmDatabase -> PmaDatabase
PROMOTIC 9.0.24 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.