Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PostgreSQL Equivalent of Logical
Message
From
12/04/2012 16:07:51
Luis Navas
Independent Consultant
Auckland, New Zealand
 
 
To
12/04/2012 07:57:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01541183
Message ID:
01541273
Views:
43
It is boolean, but in the connection string of the ODBC driver you have to include this:

BoolsAsChar=0;

Cheers

>Hi,
>
>I know there are a few people around here who've done some PostgreSQL work. What data type should I use for the equivalent of a logical field? I've tried boolean, but when I create a view that comes across to VFP as character. I've tried bit, but same thing.
I never forget a face, but in your case I will make an exception :-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform