help needed
am 12.09.2006 22:40:48 von dhfinamore------=_NextPart_000_0088_01C6D681.D1E970E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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=3Dbinary "f"
or
SELECT * FROM e02.facthead f where status=3D"f"
or
SELECT * FROM e02.facthead f where status=3Dbinary "F"
or
SELECT * FROM e02.facthead f where status=3D"F"
the problem is in visualfox because return to me only the=20
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
=20
=20
=20
Daniel Hernandez Finamore
Director Ejecutivo
ISP, S.A. de C.V.
Telefono Conmutador 0155-5243-5222
http://www.bestcommerce.com.mx
=20
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=EDa contener informaci=F3n legalmente considerada como confidencial =
y privilegiada, exenta de ser revelada a terceros. Si usted no es el =
leg=EDtimo destinatario de esta comunicaci=F3n, consid=E9rese notificado =
que est=E1 estrictamente prohibido cualquier tipo de reproducci=F3n y =
distribuci=F3n de este mensaje y cualquier documento adjunto. Si usted =
ha recibido este mensaje por error, por favor notifique inmediatamente =
esta situaci=F3n por correo electr=F3nico al remitente original y borre =
completamente de su computadora el mensaje y cualquier documento =
adjunto. Para establecer o formalizar alg=FAn 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=E9rminos y condiciones de la transacci=F3n =
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.
------=_NextPart_000_0088_01C6D681.D1E970E0--