Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical field from Oracle
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00699803
Message ID:
00699848
Views:
11
>>>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")
>
>Thanks, Hector. Your reply is more encouraging than the others, at least. Now, how do they do that behind the scenes? And can I do that?

I don't have Oracle in here so I cannot test it myself with Oracle. When I did it I was using SQL Server. Jayesh says it is not possible in Oracle, though.
Hector Correa
Previous
Reply
Map
View

Click here to load this message in the networking platform