Technical References - [exclusivelock]

Prevents other threads from simultaneously accessing a group of databases.

numero = 200
interpreted = N
texte = [exclusivelock database list]...WebDNA...[/exclusivelock] To prevent a group of databases from being modified by other threads (other 'hits' to the server, or other templates or triggers), wrap an [exclusivelock] context around the WebDNA code which will be making the important exclusive changes. Example:
[exclusivelock db=orders.db&db=lineitems.db&db=accesslog.db]...search, delete, or modify any of orders.db, lineitems.db, or accesslog.db while being assured that no other threads can modify any of these databases until the closing /exclusivelock tag is reached.[/exclusivelock]
The list of database names is first alphabetized so as to maintain a consistent locking order (a technique which prevents internal deadlocks), then each database lock is acquired one at a time until all locks are acquired, then the interior WebDNA is executed. If any lock cannot be acquired, the other databases are unlocked, and the interior WebDNA is not executed. [exclusivelock database list]...WebDNA...[/exclusivelock]

To prevent a group of databases from being modified by other threads (other 'hits' to the server, or other templates or triggers), wrap an [exclusivelock] context around the WebDNA code which will be making the important exclusive changes.

Example:

[exclusivelock db=orders.db&db=lineitems.db&db=accesslog.db]
...search, delete, or modify any of orders.db, lineitems.db, or accesslog.db while being assured that no other threads can modify any of these databases until the closing /exclusivelock tag is reached.
[/exclusivelock]


The list of database names is first alphabetized so as to maintain a consistent locking order (a technique which prevents internal deadlocks), then each database lock is acquired one at a time until all locks are acquired, then the interior WebDNA is executed. If any lock cannot be acquired, the other databases are unlocked, and the interior WebDNA is not executed.

DOWNLOAD WEBDNA NOW!

Top Articles:

F.A.Q

A compilation of some user's questions...

Download WebDNA Applications

WebDNA applications...

[biotype]

BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...

WebDNA Modules

A list of the currently available modules...

WebDNA Libraries

A list of available libraries for WebDNA...

Technical Change History

This Technical Change History provides a reverse chronological list of WebDNA changes...

Related Readings:

[SQL]

Performs a SQL statement on an ODBC data source...

[object]

Embeds the results of an external function...

[password]

Using [password] and [username] is an easy was to show the browser login dialog box...

[array]

Array Operation...

[exclusivelock]

Prevents other threads from simultaneously accessing a group of databases...

[grep]

Replaces text based on a regular expression...