Hi S�ren, I can't tell you exactly why, but it might be that it doesn't expect a column with these large numbers ?
A way to cicumwent the problem could be to create a view that does this Cast as you described it, or maybe if you are allowed to do it, change the column type in the database to another type, that MapInfo can understand. These are the types MapInfo should understand: * SQL_BIT * SQL_TINYINT * SQL_SMALLINT * SQL_INTEGER: * SQL_REAL * SQL_BIGINT * SQL_DECIMAL * SQL_DOUBLE * SQL_FLOAT * SQL_NUMERIC * SQL_BINARY * SQL_LONGVARBINARY * SQL_VARBINARY * SQL_LONGVARCHAR * SQL_DATE * SQL_TYPE_DATE * SQL_TIMESTAMP * SQL_TYPE_TIMESTAMP * SQL_TIME * SQL_TYPE_TIME * SQL_CHAR * SQL_VARCHAR The question is now is the type you are using one of these ? Med venlig hilsen, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk > -----Original Message----- > From: S�ren Breddam [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 25, 2004 11:31 PM > To: MapInfo-L (E-mail) > Subject: MI-L Wrong default types in linked DBMS table > > > Hi, > > I've come across a very odd problem with linked tables from a > SQL Server. It seems as if MI (7.0) can't import the bigger > numbers or assign the right column type when i try to link a > table with 10 digit numbers in a column. The table is by > default linked with the column type Integer and therefore > larger numbers than 2.147.483.647 are imported totally wrong. > Those values are converted from e.g 2.612.390.773 to > -1.682.576.523 (sic!) When I used the SQL Expert to import > the table and used the SQL function CAST(MyColName As Float) > (or char...) everything was fine but it was a nuisance to > write all the cols in the SQL Expert. Can anyone shed some > light over this and tell me why MI can't assign a float type > to the column by default? > > TIA > Regards > > S�ren Breddam > GIS- og IT-koordinator > Teknik og Erhvervsforvaltningen > Stevns Kommune - www.stevns.dk > * Tlf.: 5656 1800 > * Dir.: 5656 1891 > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 10600 > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10604
