sqlExec
Executes an SQL script.
sqlExec
(
query
[,
value1, ...
])
Parameters
query
The SQL query.
value1, ...
Variables of the SQL query.
Return value
The number of records updated or inserted in case of an
UPDATE
ou
INSERT
SQL command.
Remarks
Variables replace the parameters in the command. The
variable type must coincide with the parameter declared
in the command. These variables are available in a
'select' or 'update' type declaration. We have the
following types:
- $(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)
The following substitution parameters (only valid for an "update") are automatically replaced with a value and don't need a linked variable.
- $(id) Génère un identifiant
- $(id:NmsTrackingLogId) Génère un identifiant en utilisant un séquence spécifique
- $(curdate) Date et heure actuelle
The operator must have the 'sql' right to use this function, otherwise an exception is raised.
Example:
var sql4 = "INSERT INTO Reporting (sClientdesc,sClient) values ('" + client.@description.toString() + "','" + client.@clientCode.toString() +"')";
sqlExec(sql4);
Features
Available in:
- Content management
- Delivery properties
- Typology rule
- JSSP
- SOAP Method
- WebApp
- Workflow