Difference between revisions of "Cursor"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages. ====Properties==== This class supports the :Category:Commo...") |
Yvonne.milne (Talk | contribs) |
||
| Line 46: | Line 46: | ||
!Args | !Args | ||
!width="50%"|Description | !width="50%"|Description | ||
| + | |- | ||
| + | |valign="top"|_delete | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|Deletes a record from the database table on the server based on the current recno. | ||
| + | |- | ||
| + | |valign="top"|Add | ||
| + | |valign="top"|None | ||
| + | |valign="top"|Clears the internal record buffer in preparation for insert() being called after setData(). | ||
| + | |- | ||
| + | |valign="top"|GetData | ||
| + | |valign="top"|column as string | ||
| + | |valign="top"|Get the value of the specified column from the active record. | ||
| + | |- | ||
| + | |valign="top"|Insert | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|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(). | ||
| + | |- | ||
| + | |valign="top"|MoveBookmark | ||
| + | |valign="top"|record as Numeric | ||
| + | |valign="top"|Positions on the specified record in the cursor then refreshes the active record of the cursor from the server. | ||
| + | |- | ||
| + | |valign="top"|MoveFirst | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|Positions on the first record in the cursor then refreshes the active record of the cursor from the server. | ||
| + | |- | ||
| + | |valign="top"|MoveLast | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|Positions on the last record in the cursor then refreshes the active record of the cursor from the server. | ||
| + | |- | ||
| + | |valign="top"|MoveNext | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|Positions on the next record in the cursor then refreshes the active record of the cursor from the server. | ||
| + | |- | ||
| + | |valign="top"|MovePrevious | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|Positions on the previous record in the cursor then refreshes the active record of the cursor from the server. | ||
| + | |- | ||
| + | |valign="top"|Read | ||
| + | |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"|Refresh | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|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. | ||
| + | |- | ||
| + | |valign="top"|SetData | ||
| + | |valign="top"|column as Character, value as Expression | ||
| + | |valign="top"|Set the value of the specified column in the active record. | ||
| + | |- | ||
| + | |valign="top"|Update | ||
| + | |valign="top"|None * | ||
| + | |valign="top"|Updates the current record in the database table on the server containing the column data values that were changed by SetData(). | ||
|- | |- | ||
|} | |} | ||
Revision as of 13:24, 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. |
| 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 |
|---|
