Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical Field in Oracle
Message
 
 
To
30/08/2001 18:18:02
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00551118
Message ID:
00551311
Views:
14
>>Apparently, Logical/Bit datatype is not supported in Oracle.
>>
>>Is there any other solution other than making global changes to the FoxPro application?
>
>How do you access the remote data?
>If you are using views, you should be able to change the data type of the logical fields in the views to "L" with DBSETPROP().
>Then the view would handle the conversion (1=.t., 0=.f.)
>I don't have Oracle to test, but I believe that's the way it's supposed to work.

Sorry, that will not work. You get Error 1543: Type conversion required by the DataType property for field 'NumericFieldName' is invalid. I am testing with Oracle 8.1.6 and VFP 7.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform