Difference between revisions of "Cursor"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 87: | Line 87: | ||
|valign="top"|None * | |valign="top"|None * | ||
|valign="top"|Reads a record from the database table on the server based on the current recno. If the recno is greater than the reccount then the last record will be read. | |valign="top"|Reads a record from the database table on the server based on the current recno. If the recno is greater than the reccount then the last record will be read. | ||
| + | |- | ||
| + | |valign="top"|Reccount | ||
| + | |valign="top"|None | ||
| + | |valign="top"|Returns the total row count in the cursor. | ||
| + | |- | ||
| + | |valign="top"|Recno | ||
| + | |valign="top"|None | ||
| + | |valign="top"|Returns the current rowid in the cursor. | ||
|- | |- | ||
|valign="top"|Refresh | |valign="top"|Refresh | ||
Revision as of 13:38, 8 January 2015
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
Properties
This class supports the Common Properties plus the following:
| Property | Access (R/RW) | Value | Description |
|---|---|---|---|
| Bof | R | Boolean | Whether record pointer is at beginning of cursor |
| Database | R | Character | The name of the database associated with the cursor |
| Eof | R | Boolean | Whether record pointer is at end of cursor |
| Filter | RW | Character | Filter condition for the cursor |
| Table | R | Character | The name of the table associated with the cursor |
Methods
This class supports the Common Methods plus the following:
| Method | Args | Description |
|---|---|---|
| _delete | None * | Deletes a record from the database table on the server based on the current recno. |
| Add | None | Clears the internal record buffer in preparation for insert() being called after setData(). |
| GetData | column as string | Get the value of the specified column from the active record. |
| Insert | None * | Creates a new record in the database table on the server containing the column data values that were changed by setData(). Used
in conjunction with add() and setData(). |
| MoveBookmark | record as Numeric | Positions on the specified record in the cursor then refreshes the active record of the cursor from the server. |
| MoveFirst | None * | Positions on the first record in the cursor then refreshes the active record of the cursor from the server. |
| MoveLast | None * | Positions on the last record in the cursor then refreshes the active record of the cursor from the server. |
| MoveNext | None * | Positions on the next record in the cursor then refreshes the active record of the cursor from the server. |
| MovePrevious | None * | Positions on the previous record in the cursor then refreshes the active record of the cursor from the server. |
| Read | None * | Reads a record from the database table on the server based on the current recno. If the recno is greater than the reccount then the last record will be read. |
| Reccount | None | Returns the total row count in the cursor. |
| Recno | None | Returns the current rowid in the cursor. |
| Refresh | None * | Refreshes the active record of the cursor from the server based on the current filter and searchfilter conditions or the current recno if neither are specified. |
| SetData | column as Character, value as Expression | Set the value of the specified column in the active record. |
| Update | None * | Updates the current record in the database table on the server containing the column data values that were changed by SetData(). |
Events
This class supports the Common Events plus the following:
| Event | Args | Description |
|---|
