>>>>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")
>>
>>This won't work. I have tried that.
>Hum...it worked on SQL Server. There must be something different then with Oracle. Oh well....
-----
Have you tried using a 1-byte char field in Oracle containing a "T" or "F"?
I noticed that within VFP itself, you can do
ALTER TABLE mytable ALTER COLUMN mycharfield L
and it does convert "T" or "F" to .t. or .f. quite nicely.
Tom Green in Montreal