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)
The following substitute parameters are automatically replaced by a value and do not required an associated variable.
  • $(id) Generates an identifier
  • $(id:NmsTrackingLogId) Generates an identifier thanks to a specific sequence
  • $(curdate) Current date and time
The operator needs 'sql' rights to use this function, otherwise an exception is raised.

Features

Method of class: DBEngine

Available in:

  • Content management
  • Delivery properties
  • Typology rule
  • JSSP
  • SOAP Method
  • WebApp
  • Workflow