I am working on a conversion to a backend database where I have to store 0/1 to represent .F./.T.

I am using a CursorAdapter class and hoped if I set up a cursor schema that VFP could translate a backend database integer type into a logical field in the generated cursor but it does not. I get a Type conversion error.

Is there a way this can be done with the CA class?

When I use SPT like so, it translate Logical to Integer:

vTF = .T.
? SQLEXEC(m.iConn, "select * from TABLE where FIELD = ?vTF")