I sent this to the MyODBC list also, but I know that very few people watch that list. So I'm posting here as well: I have edited the MyODBC source to do a translation of TINYINT fields to BOOL fields. I have tested these thoroughly with Visual Fox Pro, and they work as logical fields, including automatic updates back via views. Because the ZIP of the new MyODBC.DLL is nearly 200k, I am not going to distrubute this as a whole to the list. But I will give anyone that asks for it the zip of the DLL, I will also gladly send them the source with my modifications if they want it. It is critical that you understand that after replacing your MyODBC.DLL with this driver, you will be unable to use TINYINT fields in their native form. All tinyint fields will be converted to BOOL fields when pulled down. Any value >0 in the field will be sent as TRUE, any 0 value will be sent as FALSE. And the translation occurs on the way up, with 1 being TRUE, and 0 being FALSE. Please let me know if you want me to send you this file. Eric Fitzgerald Server Administrator/Programmer/MySQL maintainer/Jack of all trades AMN Television Marketing --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
