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:

Add	Begin of the edit mode for adding a row
AddNew	Adds an empty row
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	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
OpenSQL	SQL statement of the SELECT type type on open
Password	Password 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
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

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 Pma object
Pm	Returns reference to the Pma object or to its implementation subobject
RemoveEvent	Unregisters 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 runtime only once at the stop of the application

Object	General information about the object
Events	Definition of object events algorithms
Database	Setting the parameters for the work with the database table

Promotic

Object PmaDatabase (Database)

Description:

Properties and methods of this object:

Obsolete properties and methods:

Properties and methods inherited from the PmaObject object:

Events inherited from the PmaObject object:

Configuration tabs:

See also:

History: