|
1.17. A calculated field of type LOGICAL will create a column with a numeric type as in the following example:
SELECT nF1,lF2 ... and lF2 has a BIT type.
If you have an expression like this:
Select F1,~m.True as F2 ...
where m.True is a logical FoxPro variable, then the result cursor will include a column named F2
N(1). As SQL will accept a constant 1 as numeric type, the E_SQL_Find_Variables function will convert this statement to:
Select F1, cast (1 as bit) as F2 ...
back
to features list
|
