- EXPRESSION_INFO Function
/pages/Ref/Api/Functions/Document Types/DBF/Query Functions/EXPRESSION_INFO Function.xml
Takes an expression and gets information about it.
type - expression type
ref_tabl - 'T' if references any table
eref_children - 'T' if references children
ref_one_to_manys - 'T' if references one-to-many children
table_names - tables referenced
field_names - field referencedleaves - leaf expression (conditional)
- Expression Library
The Expression Library stores expressions that can be inserted into your script with only a couple of keystrokes.
- a5_validate_Xbasic_expression Function
/pages/Ref/Api/Functions/Xbasic/Expression Evaluation Functions/a5_validate_xbasic_expression Function.xml
Validates an Xbasic expression
- a5_rtf_insert_expression Function
/pages/Ref/Api/Functions/Document Types/RTF Functions/a5_rtf_insert_expression Function.xml
Inserts an Expression into a Static RTF Object. For Internal Use Only.
- Expression Builder
Whenever you want to enter an expression, clicking the 'xy' icon you displays the Expression Builder. The Expression Builder provides access to all the inputs required to build any type of expression. This includes...
- template_to_expression Function
/pages/Ref/Api/Functions/Xbasic/Expression Evaluation Functions/template_to_expression Function.xml
From a template, following cr-lf delimited rules, convert to expression.
- table.to_sql_expression Function
If convertable to a SQL level expression, return than expression.
- expression_encode Function
/pages/Ref/Api/Functions/Xbasic/Expression Evaluation Functions/expression_encode Function.xml
Encodes an exression that contains parameter placeholders.
- SQL::Connection::PrimaryKeyExpression Function
Return the primary key expression for a Table.
- Query by Expression
/pages/Guides/Desktop/Design/View/Form/Query/Query by Expression.xml
The Query by Expression dialog box is available when viewing both forms and browses, and lets you filter and sort records by directly entering filter and order expressions. Query by Expression is primarily intended for experienced users who are more comfortable writing expressions than using Genies.