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

You can do this with a VFP remote view, but I don't think you can do it with SQL pass-through.

With a remote view, you can cast a numeric value to be converted to a logical VFP value with something like:

DBSetProp('YourView.YourNumField', 'Field', 'DataType', "L")