Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Object PmDatabase (Database)

Description:
This object represents one database table. By 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 use the PmAdo object.

 
No other PROMOTIC objects can be created in this object. This object can be created in the PmRoot, PmFolder and PmPrototype objects. Multiple objects of this type can be created in such objects.

The PmDatabase object is bound on the 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 PmDatabase 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 PmObject
Properties and methods:
Add Begin of the edit mode for adding a row
AddNew Adding 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 Creation of the column in the table structure
CreateIndex Creation of the index over the column of the database table
Database Path and name of a database file
Delete Delete the record on the current position in the database table
DeleteTable Delete 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
FieldValues Value of the column in the current row
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 Creating array or matrix of values read from selected table columns
GetFieldCount Getting the number of columns in the database table
GetFieldInfo Getting the information about columns in the database table
GetRecordCount Getting the rough number of rows in the database table
IsBOF Test if the current pointer position is at the beginning of the database table
IsConnect Test if the database is connected
IsEOF Test if the current pointer position is at the end of the database table
IsOpen Test if 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
Requery Re-reading the content of the table
RollBack Rollback of the transaction processing of the table
SetLockingMode Setting the row locking mode
SetNullValue Setting the "Null" value
SetParam Setting parameters of the PmDatabase 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
Configuration windows:
Object General information about the object
Content Content of the object in the XML form
Events Definition of object events algorithms
Database Parameters settings for the work with the database table
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice