This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D SQL Reference
-
- Syntax rules
-
-
Syntax rules
-
4d_function_call
-
4d_language_reference
-
all_or_any_predicate
-
arithmetic_expression
-
between_predicate
-
case_expression
-
column_definition
-
column_reference
-
command_parameter
-
comparison_predicate
-
exists_predicate
-
foreign_key_definition
-
function_call
-
in_predicate
-
is_null_predicate
-
like_predicate
-
literal
-
predicate
-
primary_key_definition
-
search_condition
-
select_item
-
sort_list
-
sql_data_type_name
-
sql_name
-
sql_string
-
subquery
-
table_constraint
-
table_reference
-
arithmetic_expression
|
column_reference | function_call | command_parameter | case_expression | (arithmetic_expression) | + arithmetic_expression | - arithmetic_expression | arithmetic_expression + arithmetic_expression | arithmetic_expression - arithmetic_expression | arithmetic_expression * arithmetic_expression | arithmetic_expression / arithmetic_expression | |
||
An arithmetic_expression may contain a literal value, a column_reference, a function_call, a command_parameter or a case_expression. You can also pass combinations of arithmetic_expression(s) using the +, -, * or / operators.
case_expression
column_reference
command_parameter
function_call
INSERT
Product: 4D
Theme: Syntax rules
4D SQL Reference ( 4D v20 R8)
