Found out that gpre isn't compiled after versions 1.5. Have a consultant recompiling firebird 2.5.2 to get the gpre back. Should be back to normal by tomorrow.
--- In firebird-support@yahoogroups.com, Frank Schlottmann-Gödde <frank@...> wrote: > > On 30.07.2013 23:29, Kevin E wrote: > > When running a COBOL code through gpre: > > > > > > EXEC SQL > > SET DATABASE DB2 = "/Db/Iccb/a1.db"; > > USER '******' PASSWORD '********' > > END-EXEC. > > EXEC SQL > > DECLARE C CURSOR FOR > > SELECT DISTRICT, COLLEGE FROM DB2.CAMPUS > > WHERE FICE = :FICE > > END-EXEC. > > EXEC SQL > > OPEN C > > END-EXEC. > > EXEC SQL > > # Error on the following line "column count and number of INTO list > > host-variables unequal > > # FETCH C INTO :CAMPUS-DIST, :CAMPUS-COLL > > END-EXEC. > > MOVE SQLCODE to D-SQLCODE. > > EXEC SQL > > CLOSE C > > END-EXEC. > > > > This should be pretty straight forward but am I missing something here. > > This very code has been working for over 15yrs. Having to re-compile > > everything for new system. > > Trying to get our first code through the pre-processor. Just upgraded to > > Firebird 2.5 64bit. > > > > Any ideas? > > Looks like it should work. > > As gpre and COBOL aren't widely used anymore, this could be a bug in gpre. > > What version did you use before? > > > fsg > > -- > "Fascinating creatures, phoenixes, they can carry immensely heavy loads, > their tears have healing powers and they make highly faithful pets." - > J.K. Rowling >