[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: help needed
From:       Mike Harknett <mike.harknett () kiwiplan ! co ! nz>
Date:       2006-09-12 20:45:50
Message-ID: 45071C7E.6050800 () kiwiplan ! co ! nz
[Download RAW message or body]

Try using where
status in ('F','f')
or Lower(status) = 'f'

cheers

mike

dhfinamore@hotmail.com wrote:
> Hi, I are working with visualfox 6.0 and mysql server 4.1 and odbc driver \
> 3.51.11.00 11 feb 2005 
> I have a table with a column char(1) and some records have "F" or "f"
> this examples works fine on the query browser:
> 
> SELECT * FROM e02.facthead f where status=binary "f"
> or
> SELECT * FROM e02.facthead f where status="f"
> or
> SELECT * FROM e02.facthead f where status=binary "F"
> or
> SELECT * FROM e02.facthead f where status="F"
> 
> the problem is in visualfox because return to me only the 
> records with "F" ignoring the records with "f" in all the 4 examples
> 
> this sounds like a bug on the odbc driver, what can I do?
> 
> Daniel
> 
> 
> 
> 
> Saludos
> 
> 
> 
> Daniel Hernandez Finamore
> Director Ejecutivo
> ISP, S.A. de C.V.
> Telefono Conmutador 0155-5243-5222
> http://www.bestcommerce.com.mx
> 
> Este mensaje y cualquier documento que se adjunte, son para el uso exclusivo de la \
> persona o entidad a la cual se encuentra dirigido y podría contener información \
> legalmente considerada como confidencial y privilegiada, exenta de ser revelada a \
> terceros. Si usted no es el legítimo destinatario de esta comunicación, considérese \
> notificado que está estrictamente prohibido cualquier tipo de reproducción y \
> distribución de este mensaje y cualquier documento adjunto. Si usted ha recibido \
> este mensaje por error, por favor notifique inmediatamente esta situación por \
> correo electrónico al remitente original y borre completamente de su computadora el \
> mensaje y cualquier documento adjunto. Para establecer o formalizar algún tipo de \
> acuerdo entre ISP, S.A. de C.V. y su compañía, es necesario que se firme por los \
> representantes legales de ambas compañías un acuerdo por escrito que incluya todos \
> los términos y condiciones de la transacción respectiva. 
> This message, together with any attachments, is intended only for the use of the \
> individual or entity to which it is addressed and may contain information that is \
> legally privileged, confidential and exempt from disclosure. If you are not the \
> intended recipient, you are hereby notified that any dissemination, distribution, \
> or copying of this message, or any attachment, is strictly prohibited. If you have \
> received this message in error, please notify the original sender immediately by \
> return E-mail and delete the message, along with any attachments, from your \
> computer. In order to establish a formal agreement between ISP, S.A. de C.V. and \
> your company, it is necessary to execute a written document signed by the proper \
> representatives of each company, including all the terms and conditions of the \
> relevant transaction. 
> 
> 
> 



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]