The following constants can be used anywhere in macros or scripts in place of the actual values.
If you are retrieving the value of a property or parameter, scripts or macros will return the integer value, whereas Inspector will display the constant equivalent.
When using constants in the script editor, each constant must be prefaced by nl.
Move Option constant (macro editor) |
Move Option constant (script editor) |
Value |
Description |
DBMoveFirst |
nlDBMoveFirst |
1 |
Move to the first record in the Recordset object. For ADO data sources, support for this option varies depending on the OLE DB provider and the Cursor Type that was specified when the recordset was opened. This action may not be supported in some recordsets. |
DBMoveLast |
nlDBMoveLast |
2 |
Move to the last record in the Recordset object. For ADO data sources, support for this option varies depending on the OLE DB provider and the Cursor Type that was specified when the recordset was opened. This action may not be supported in some recordsets. |
DBMoveNext |
nlDBMoveNext |
3 |
Move to the next record in the Recordset object. |
DBMovePrevious |
nlDBMovePrevious |
4 |
Move to the previous record in the Recordset object. For ADO data sources, support for this option varies depending on the OLE DB provider and the Cursor Type that was specified when the recordset was opened. This action may not be supported in some recordsets. |
© 2004-2021 looksoftware. All rights reserved.