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

[Hauser, K. <Kar...@ib...>]

Both fields are numeric.. Your statement delivers the result set (1->Number, ADMIN->String) and is the base for following statement 'SELECT "NR" FROM "PERSONAL" WHERE ?="NR"' send to firebird while during excecution the sign '?' should be replace by the number 1 (from result set). There somewhere is the failure.

-----Ursprüngliche Nachricht-----
Von: Frank Schlottmann-Gödde [mailto:fs...@us...] 
Gesendet: Dienstag, 13. Januar 2009 16:00
An: fir...@li...
Betreff: Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird

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

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

------------------------------------------------------------------------------------------------------------
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter /
Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble