But does he mean that they are all True whereas some should be False? John Weller 01380 723235 07976 393631
> -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of MB > Software Solutions, LLC > Sent: 05 March 2013 15:50 > To: [email protected] > Subject: Re: bit field in mysql > > On 3/2/2013 1:45 AM, MANJIT JHA wrote: > > dear sir/madam > > i have a bit field in mysql table in which values are 0 or 1, but when i take > data in cursor through sqlexec command in vfp9(sp2) it becomes T for all > records regardless of 0/1 in mysql. > > > The ODBC driver interprets the bit field (correctly I might add) as a logical > field. If you truely want 0/1, then make it a TinyInt field in MySQL. > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
