Variables

​

Introduction

Variables and constants store values you can later use anywhere in your query.

​

Basic Usage

Variables are placeholders that can be assigned and reassigned values throughout the SQL code.

To assign a value to a variable, use the equal sign = followed by the value.

{name = 'foo'}
{age = 30}
{sum = 2 + 4} 

For example, take a look at the following Latitude Query, and what will actually be compiled and executed in the database:

​

Incrementing

Variables can be modified using operations such as addition.

​

Constants

Constants are similar to variables but, once defined, their value cannot be changed. Also the main syntax difference is constants are defined using the @const keyword.

{@const name = 'value'}

{@const birthday = '2000/02/28'} /* Defined a constant */

SELECT *
FROM table
{#if birthday = '2000/02/28'}
    {birthday = '2024/12/31'} /* Reassigning the constant */
{/if}

'!Error: Cannot reassign a constant'

​

Scope

​

Global

Variables defined outside of any logic blocks are considered global and can be modified and accessed throughout the entire code.

{var1 = 'latitude'}

Variables can be accessed and modified anywhere in the code.

​

Local Variables

Variables defined within logic blocks are local to that block. They cannot be accessed outside the block in which they are defined.

{#if condition}
    {var2 = 'localValue'} /* Accessible only within this block */
{/if}