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
