Re: What is the difference between Version 7 and Version 10 IDS?

Michael Andreas wrote: > Hi, > > using the following SQL-Command I copy very fast a lot of rows > from a INFOMIX DB (source) into a ACCESS DB (destination): > > INSERT INTO tab SELECT * FROM [ODBC;DSN=DB;UID=name;PWD=test;].tab WHERE> tab_typ = 50; > > After changing the IDS Server from version 7 to version 10 I allways get the > message "Types incompatible". Why? > > The column-types are serial, integer and char. > > Is there anyone who is able to help me? Try casting the SERIAL column to INTEGER: INSERT INTO tab SELECT INTEGER::serial_col, col2, col3,... Art S. Kagel