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 |
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() | 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 |
OpenSQL | SQL statement of the SELECT 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 "empty value" |
SetParam() | Sets parameters of the PmaDatabase object |
SetRecordValueNull() | Writing the "empty value" into the item |
SetRecordValuesNull() | Writing the "empty 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 |