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:
Add()Beginning of the edit mode for adding a row
AddNew()Adds an empty row
BeginTrans()Beginning of transaction
CancelUpdate()End of the edit mode, changes canceling
Close()Close the database table and the database
CloseTable()Close the table (the database remains open)
Commit()Confirmation of the transaction
CompactDatabase()Defragmentation of the Access database
Connect()Connection of the database to the application
Create()Beginning of the creation table mode
CreateEnd()End of the creation table mode
CreateField()Creates the column in the table structure
CreateIndex()Creates the index over the column of the database table
DatabasePath and name of a database file
Delete()Deletes the record on the current position in the database table
DeleteTable()Deletes the database table
Edit()Beginning of the edit mode
Execute()Execute the statement in the SQL language syntax
ExecuteSQL()Execute the statement in the SQL language syntax
ExistTable()Test for the occurrence of the table in the database
FindFirst()Search for the text string in the database table from beginning of the table
FindLast()Search for the string in the database table from the end of the table
FindNext()Search for the string in the table from the current position forward
FindPrev()Search for the string in the table from the current position backward
GetArray()Creates an array or matrix of values read from selected table columns
GetFieldCount()Returns the number of columns in the database table
GetFieldInfo()Returns the information about columns in the database table
GetRecordCount()Returns the rough number of rows in the table
IsBOF()Test whether the current pointer position is at the beginning of the database table
IsConnect()Test whether the database is connected
IsEOF()Test whether the current pointer position is at the end of the database table
IsOpen()Test whether the database table is opened
Move()Move the current position by the specified number of records
MoveFirst()Move the current position to the beginning of the database table
MoveLast()Move the current position to the end of the database table
MoveNext()Move the current position by one record forward in the table
MovePrev()Move the current position by one record backward in the table
MoveTo()Move the current position to the specified record in the table
Open()Open the database table
OpenSQLSQL statement of the SELECT type on open
PasswordPassword for an access to databases/tables
ReadFieldValue()Returns a value of the column in the current row
Requery()Re-reading the content of the table
RollBack()Rollback of the transaction processing of the table
SetLockingMode()Sets the row locking mode
SetNullValue()Sets the "Null" value
SetParam()Sets parameters of the PmaDatabase object
SetRecordValueNull()Writing the "Null" value into the item
SetRecordValuesNull()Writing the "Null" value into the whole record
TableTable name
TypeDatabase type
Update()End of the edit mode, writing changes
UserUser name
WriteFieldValue()Sets 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:
AddEvent()Registers a function into the specified event
GetInfo()Returns the Info object with the specified name
GetOwnedByIndex()Returns the subobject defined by its index
GetOwnedByName()Returns reference to the subobject defined by its name
GetOwnedByType()Array of references to the subobjects
GetOwnedNum()Returns number of subobjects in the object
GetPar()Reading the value of the Pma object parameter (or its parents)
GetPathName()Object name with the path to this object
GetPermission()Returns 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
Pm()Returns reference to the Pma object or to its implementation subobject
RemoveEvent()Unregisters 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 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.27 SCADA system documentation MICROSYS, spol. s r.o.

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