RE: [U2] Error in sentence SQL

2005-09-06 Thread César Riba Cervera
HERE CAST(GCMCL.CODIGOTXT AS VARCHAR) = CAST(LINFAC.CODCLI AS VARCHAR); > > But do report it. > > - Original Message - > From: "Cisar Riba Cervera" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: [U2] Error in sentence SQL > Date:

Re: [U2] Error in sentence SQL

2005-09-05 Thread Ray Wurlod
HAR); But do report it. - Original Message - From: "Cisar Riba Cervera" <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Subject: [U2] Error in sentence SQL Date: Mon, 5 Sep 2005 12:00:18 +0200 > > Hello > > I recive this error when I execute this

[U2] Error in sentence SQL

2005-09-05 Thread César Riba Cervera
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