letservervariable
VARIABLE
=
VALUE

The letservervariable statement creates a server variable and assigns a value to it.


Parameters

This statement has two parameters:

variable – is the name of the variable that you want to create.

value – calculates the value that will be placed into the variable.


Description

This statement works just like an assignment, but the destination of the assignment is a server variable (associated with the current database, which must be a shared database). Instead of being stored on the local computer, server variables are stored on the server, where they can be accessed by any computer that has access to the server.

For example, this statement creates a server variable named pageCount and assigns the value 23 to it.

letservervariable pageCount=23

The value can be any data type, for example text like this:

letservervariable userName="Bob"

Later, the server variable can be accessed by using the servervariable( function, for example:

servervariable("userName") ☞ Bob

Note: This statement is based on the assignservervariable statement, but letservervariable uses an equal sign between the variable name and the value, instead of a comma. The assignservervariable statement also lets you optionally specify an alternate database, and optionally allows the variable name to be calculated with a formula.

IMPORTANT: If you want to modify a shared value by incrementing, decrementing or appending to it, use the adjustservervariable statement or the adjustservervariable( function instead of the letservervariable statement. These operations are designed to correctly modify a shared value in a multi-user environment, so that the correct value is generated even if two or more users on different computers modify the value at the same time.


See Also


History

VersionStatusNotes
10.2NewNew in this version.