Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Object PmaDatabase (Database)

Description:
This object represents one database table. By means of this object the data from the database 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. With the freeware version PmFree, or when developing the application (with development environment for testing purposes), this component is always functional.

It isn't required to install the database system on 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 adopts properties and methods of the PmaObject object.
:
Add Begin of the edit mode for adding a row
AddNew Adds an empty record
BeginTrans Begin of transaction
CancelUpdate End of the edit mode, changes canceling
Close Closing the database table and the database
CloseTable Closing 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 Begin 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
Database Path and name of a database file
Delete Deletes the record on the current position in the database table
DeleteTable Deletes the database table
Edit Begin 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 Searching for the string in the database table from beginning of the table
FindLast Searching for the string in the database table from the end of the table
FindNext Searching for the string in the table from the current position forward
FindPrev Searching 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
OpenSQL SQL statement of the SELECT type type on open
Password Password for an access to databases/tables
ReadFieldValue Returns the 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
Table Table name
Type Database type
Update End of the edit mode, writing changes
User User name
WriteFieldValue Sets the value of the column in the current row
Obsolete properties and methods:
FieldValues Value of the column in the current row
:
AddEvent Registers a function into selected 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
Methods Access to designer's methods of this object
Name Object name (without the path)
Parent Returns reference to the parent object in the tree of Pma objects
Pm Returns reference to the Pma object or to its implementation subobject
RemoveEvent Un-registers the function in the specified event
Root Returns reference to the root application object PmaRoot
:
onStart Is triggered for each object in the runtime only once at the beginning
onStop Is triggered for each Pma object in the runtime mode only once at the stop of the application
Configuration tabs:
Object General information about the object
Events Definition of object events algorithms
Database Setting the parameters for the work with the database table

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

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice