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 |