Thanks Ray
With the function CAST I resolve the problem.
> -----Mensaje original-----
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] nombre de Ray Wurlod
> Enviado el: lunes, 05 de septiembre de 2005 22:30
> Para: [email protected]
> Asunto: Re: [U2] Error in sentence SQL
>
>
> That's a bug. Report it.
>
> Try moving the join condition into a WHERE clause:
> SELECT GCMCL.* FROM GCMCL, LINFAC WHERE GCMCL.CODIGOTXT = LINFAC.CODCLI;
>
> If that doesn't work, try a CAST:
> SELECT GCMCL.* FROM GCMCL, LINFAC
> WHERE CAST(GCMCL.CODIGOTXT AS VARCHAR) = CAST(LINFAC.CODCLI AS VARCHAR);
>
> But do report it.
>
> ----- Original Message -----
> From: "Cisar Riba Cervera" <[EMAIL PROTECTED]>
> To: [email protected]
> Subject: [U2] Error in sentence SQL
> Date: Mon, 5 Sep 2005 12:00:18 +0200
>
> >
> > Hello
> >
> > I recive this error when I execute this sentece SQL
> >
> > > SELECT GCMCL.* FROM GCMCL INNER JOIN LINFAC ON GCMCL.CODIGOTXT =
> > LINFAC.CODCLI;
> > UniVerse/SQL: number and character types are incompatible
> in this operation
> > Scanned command was FROM GCMCL INNER JOIN LINFAC ON
> GCMCL.CODIGOTXT =
> > LINFAC.CODCLI SELECT
> >
> > The fields DICT for the two fields are:
> >
> > >ED DICT GCMCL CODIGOTXT
> > 8 lines long.
> >
> > 0001: D
> > 0002: 0
> > 0003:
> > 0004: COD_CLI
> > 0005: 6L
> > 0006: S
> > 0007:
> > 0008: VARCHAR,6
> >
> > >ED DICT LINFAC CODCLI
> > 8 lines long.
> > 0001: D
> > 0002: 10
> > 0003:
> > 0004:
> > 0005: 6L
> > 0006: S
> > 0007:
> > 0008: VARCHAR,6
> >
> >
> > Can help me.
> >
> > Tanks
> >
> > Best Regarts
> >
> > Cisar Riba Cervera
> > Spain
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.344 / Virus Database: 267.10.18/89 - Release Date:
> 02/09/2005
> > -------
> > u2-users mailing list
> > [email protected]
> > To unsubscribe please visit http://listserver.u2ug.org/
> -------
> u2-users mailing list
> [email protected]
> To unsubscribe please visit http://listserver.u2ug.org/
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.10.18/89 - Release Date: 02/09/2005
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/90 - Release Date: 05/09/2005
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
