Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which back-end data type for logical field in remote vi
Message
 
To
15/07/1997 16:35:55
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00040061
Message ID:
00040120
Views:
28
>>I need to add an analog of VFP logical field to Sybase table through SQL Anywhere. Can anybody tell me what data type I need to choose?
>>It seems to be BIT data type, but in VFP remote view I see it converted into INTEGER.
>>
>>Nick
>
>Hi, Nick!
>Did you try to use DBSETPROP() to reset DataType property?

Hello Edward,

Yes, I tried, it works for the view ( I mean the property is changed), but when I try to browse the view, I get the error message:
"Type conversion required by the DataType property for field MyField is invalid"

So, I mean - what data type at the back end is the closest analog to VFP logical field?
For now I just use that integer field with values 0 and 1, but I would like it to be .F. and .T.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform