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
-
literal
|
|
||
A literal is a data type consisting of either an int_number (integer), a fractional_number (fraction), an sql_string or a hexadecimal_number.
Hexadecimal notation (introduced in 4D 12.1) can express any type of data represented as bytes. A byte is always defined by two hexadecimal values. To indicate the use of this notation in an SQL command, you must simply use the standard SQL syntax for hexadecimal values:
X'<hexadecimal value>'
For example, for the decimal value 15, you can write X'0f'. You can set a blank value (zero byte) by writing X''.
Note: The and commands export binary data in hexadecimal format when these data are embedded in the main export file.
Product: 4D
Theme: Syntax rules
4D SQL Reference ( 4D v20 R8)
