Syntax

Production > Variant production > Product configurator > Syntax

The product configurator uses various syntax. Parameters are used in square brackets ("[","]").

A Syntax verification of formulas is only possible for SQL syntax via the "Check"-Button.

For visibility rules only the condition is checked.

Example with SQL syntax:

[numberofseats]=2 or [numberofseats]=3

In this case, the statement is:

select case when [numberofseats]=2 or [numberofseats]=3 then 1 else 0 end

Note:        

For more information on the possible mathematical and logical functions with SQL please consult the SQL database documentation.

Warning:

The product configurator uses SQL syntax, parameter are enclosed in square brackets ("[","]").

Conversely, the variant generator in the formula area uses the Sybase DataWindow syntax. Variables do not have to be enclosed within brackets.

Note:

If you use decimal numbers (numeric values with decimal places) in formulas, you must also tell the system that the decimal places are to be counted. Otherwise, only integers are expected.

Some MS systems, as well as MS SQL servers, must be informed of this explicitly.

Example:

2 variables: value1=10, value2=20

-> [value1] / 1000 * [value2] brings up a "wrong" result: 0

-> [value1] / 1000.0 * [value2] calculates the "correct" result: 0,2

Example of the product configurator syntax for visible rules