execute
Executes a SQL command.
execute
(command
[, value1,
...
])
Parameters
command
SQL command.
value1, ...
Variables of the command.
Return value
The number of records updated or inserted if applicable to the command executed, otherwise zero.
Remarks
The variables are used to substitute for the parameters of
the command. The variable type must match the type declared
in the command. The types are the following:
- $(sz) string
- $(m) memo
- $(l) long
- $(s) short
- $(b) byte
- $(d) double
- $(f) float
- $(ts) timestamp
- $(dt) date
- $(tm) time
- $(dur) timespan en millisecondes (ms)
- $(id) Generates an identifier
- $(id:NmsTrackingLogId) Generates an identifier thanks to a specific sequence
- $(curdate) Current date and time
Features
Method of class: DBEngine
Available in:
- Content management
- Delivery properties
- Typology rule
- JSSP
- SOAP Method
- WebApp
- Workflow