Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Boolean and MySQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00957978
Message ID:
00957980
Views:
9
This message has been marked as a message which has helped to the initial question of the thread.
Hi Stefane,

ORACLE doesn't BOOLEAN type too. I use NUMBER(1) for emulating .T./.F.

MartinJ



>There was a display problem with my previous msg.
>So here it is again.
>
>Hello,
>
>I get a cursor from a MySQL table with a SQLEXEC().
>I need to retrieve a value from a boolean field (.T. or .F.).
>But I can't find a field datatype in MySQL wich correspond to a boolean.
>I absolutely need to get .T. or .F. from this field because I'm not only connecting to MySQL but also other backends.
>Is there an issue ?
>
>Thanks for your help.
>Regards,
>Steph
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Reply
Map
View

Click here to load this message in the networking platform