>How do I create the equivalent of a logical field in Oracle, which becomes a VFP logical field when I do a SQLEXEC("select *...") ?

The best you can do is a 1 digit numeric that accepts 0 or 1 values. A VFP checkbox will treat a 0 as false and 1 as true. As for SPT, retrieve the data into a temp cursor, then issue a second SQL on the cursor --

IF SQLEXEC(nHandle, 'SELECT * FROM ORACLE_TABLE', 'crsTemp') > 0
   SELECT (field1=1) field1 FROM crsTemp INTO CURSOR crsFinal
ENDIF