| 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 the database file |
|---|
| Delete() | Deletes the record on the current position in the database table |
|---|
| DeleteTable() | Deletes the table from the database |
|---|
| 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 access into the database/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 |
|---|
