Larry Bradley wrote: > VFP handles mySQL BIT fields just fine, it appears, in remote views and > cursor adapters. I've never used tinyint() for VFP logical fields. > > And of course when looking at the mySQL table definitions, it is obvious > that a BIT(1) is a logical, whereas a tinyint() could be anything. > >
I've used tinyint(1) in the past when I was connecting to a MySQL4 database, and it worked just fine. Bit field type wasn't available prior to MySQL5, iirc. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.