Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Remote view logical field problem
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement