SQL Where Clause (Magic xpa 4.x)
The SQL Where Clause allows you to use the SQL-specific Where clauses in addition to the Where clauses generated automatically by Magic xpa, without the need to use Direct SQL tasks.
This is an interface for writing Ranges based on SQL syntax using Magic xpa variables. This range will be concatenated to the Magic xpa Where clause defined in the Range dialog box.
An SQL Where form will enable the programmer to specify a range, and to view the full Where clause that will be generated by Magic xpa.
For IBM i databases, the Open Query File tab is seen instead of the SQL Where tab.
For Space databases, when using a constant value in the SQL Where clause, it will be trimmed according to the SQL type. If no SQL type is defined, the value will be trimmed for Unicode columns and will not be trimmed for Alpha columns.
The SQL Range is not supported for local data sources.
Magic xpa SQL Where Range Expression
DB SQL Where
Full Where Clause
Magic xpa SQL Where and DB SQL Where Behavior
Magic xpa SQL Where and DB SQL Where Usage Considerations
Magic xpa SQL Functions
Range
Range Expression
How Do I Send My Own SQL Statements to the Database?
