I am trying to create a remote view which selects all fields from a SQL table, plus an extra logical field (not related to any back-end field).

Using native tables, I could use syntax like...

SELECT *, .F. AS MyNewField ;
FROM MySQLTable ;
WHERE MyFilterCondition

but I get an 'incorrect syntax near AS...' ODBC error message. If I use '0 as MyNewField' it defaults to an integer field and if I then try and change the field data-type to logical, I get the error message 'Type conversion required by the DataType property for field "MyField" is invalid' (Error 1543).

There are other bit fields in the backend table which translate fine to logical fields, so how can I add a logical field to my field list, or am I restricted to using 1/0 as an integer?

Many thanks,
Alan