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.
|
Command Type constant (macro editor) |
Command Type constant (script editor) |
Value |
Description |
|
DBCmdFile |
nlDBCmdFile |
256 |
The database source is the file name of a persistently stored Recordset. |
|
DBCmdStoredProc |
nlDBCmdStoredProc |
4 |
The database source is a stored procedure name. |
|
DBCmdTable |
nlDBCmdTable |
2 |
The database source is a table name whose columns are all returned by an internally generated SQL query. |
|
DBCmdTableDirect |
nlDBCmdTableDirect |
512 |
The database source is a table name whose columns are all returned. To use the DBSeek action or Seek method, the Recordset must be opened with DBCmdTableDirect |
|
DBCmdText |
nlDBCmdText |
1 |
The database source is a textual definition of a command or stored procedure call. |
|
DBCmdUnknown |
nlDBCmdUnknown |
8 |
The database source is unknown. |
|
DBCmdUnspecified |
nlDBCmdUnspecified |
-1 |
The database source is unspecified. |
© 2004-2021 looksoftware. All rights reserved.