PROCESS |INSTRUCTIONS | COMMANDS
Generated on Fri May 16 17:38:20 CEST 2003
COMMANDES
actionlog.create
color.modify
credit-card.check-number
cron.create
cron.modify
cron.remove
document.execute
domain.create
domain.remove
file.copy
file.delete
file.extract-text
file.link
file.move
file.touch
folder.create
group.add-user
group.create
group.remove
group.remove-user
http.redirect
http.request
image.resize
instance.append-field
instance.create
instance.increment-field
instance.modify
instance.remove
instance.remove-field
instance.remove-locale-content
ldap.create
ldap.modify
ldap.remove
license.sign-file
messageboard.add
object-field.create
object-field.modify
object-field.remove
object.create
object.modify
object.remove
parked-domain.create
parked-domain.remove
privilege.create
privilege.remove
processing-instruction.add
publication-list.create
publication-list.modify
publication-list.remove
publication.create
publication.link
publication.modify
publication.remove
publication.unlink
right.create
right.remove
security.create-encryption-key
security.create-signature-key
security.decrypt-string
security.encrypt-string
security.keystore-create-key
security.keystore-remove-key
security.sign-namespace
site.create
site.exist
site.export
site.modify
site.remove
site.swap
smtp.send
soap.request
sql.delete
sql.increment
sql.insert
sql.update
user.authenticate
user.create
user.exist
user.login
user.logout
user.mail-password
user.modify
user.remove
webservice.request
sql.increment
 

description
Transactionnally increment a value in data line of an SQL table using primary key field/value as WHERE statement.

privilege-required
root

tx-support
true
 
 INSTRUCTION 
name type default-value required description
logical-db-name string none true Logical database name as defined in the application server.
field string none true The field to increment.
primary-key-field string none true Primary key field.
table string none true Table name.
primary-key-value string none true Primary key value used for the WHERE statement.
 
 EXAMPLE 

example 1 
<nvd:command name="sql.increment" logical-db-name="db1" table="maintable" primary-key-field="id" primary-key-value="45" field="notation"/>