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 much better to 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.

Usage of the PmaDatabase object requires purchase of the PmDB license. With the freeware version PmFree, or when developing the application (with development environment for tersting 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 object PmaObject.
Properties and methods:
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 entered in the SQL language
ExecuteSQL Execute the statement entered in the SQL language
ExistTable Test for the occurrence of the table in the database
FindFirst Searching for the string in the database table from the begin 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 database table from the current position forward
FindPrev Searching for the string in the database 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 database 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 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
Configuration windows:
Object General information about the object
Content Content of the object in the XML form
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.7 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