Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird

[Frank Schlottmann-G. <fs...@us...>]

Hauser, Karsten wrote:
> 
> 
> Hi,
> 
>  
> 
> I have the following Problem with the combination of Firebird 1.5.x or
> 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system:
> 
>  
> 
> the command:
> SELECT pe.NR, us.USER_LOGIN
> FROM IBKPVS_SYS_USER us
> LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR
> where us.USER_LOGIN = 'ADMIN'
> ends up in this error msg:
> conversion error from string " "


Seems that either IBKPVS_SYS_USER.USER_PERS_ID_FK is declared as numeric
type and PER...@fo... is declared as char typ and contains ' '
(or null ?) or vice versa.

What does

Select SELECT us.USER_PERS_ID_FK,us.USER_LOGIN
FROM IBKPVS_SYS_USER us
where us.USER_LOGIN = 'ADMIN'

return?


mit freundlichen Grüßen
Frank Schlottmann-Gödde
-- 
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
  their tears have healing powers and they make highly faithful pets."
      - J.K. Rowling