Centura & MySql ODBC Bug

------=_NextPart_000_0042_01C59A10.1A97FE10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've got a problem with char variable and SqlWindows the problem is with =
bind variables in the clause where

Varibles
nVal: Number
sStr: String

Query #1
SELECT med_dni, med_tel FROM medicos WHERE med_codigo =3D 1 INTO :nVal, =
:sStr=20

Values
nVal sStr
1 XXX
2 YYY
... .....

Query #2
SELECT med_dni, med_tel FROM medicos WHERE med_codigo =3D :form.dfCodigo =
INTO :nVal, :sStr=20

Values
nVal sStr
1 =20
2
...

Query #3
SELECT med_dni, med_tel FROM medicos WHERE med_codigo =3D \' || =
SalFmtFormatNumber ( form.dfCodigo ) || \' INTO :nVal, :sStr

Values
nVal sStr
1 XXX
2 YYY
... .....

Only return char values in the case 1 and 3. All case return number =
values.
I hope anyone know how can I fix the problem
Tanks
------=_NextPart_000_0042_01C59A10.1A97FE10--






___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar