Yes, hopeless, isn't it? When many people need to consider all of their data (the non-spatial stuff) in the context of its spatial location, and when that data may be disposed in numerous well-normalized tables elsewhere in the enterprise, having these sorts of limits is insane.
Even with the expensive middleware, it's a poorly-designed system. It makes MI seem like a toy that has outgrown its relevance. IL Thomas GeoSciSoft - Perth, Australia > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:mapinfo-l- > [EMAIL PROTECTED] On Behalf Of Søren Breddam > Sent: Tuesday, January 24, 2006 3:59 PM > To: Bill Thoen; [email protected] > Subject: Re: [MI-L] Number of fields > > Hi, > > I just tested this: You can add a Logical field until you reach 250 fields > (at least MI800). If you try this with a Char (254) you can only have 15 ! > MI gives a note that a record lenght can't exceed 4000 bytes. > > Venligst > > Søren Breddam > Stevns Kommune - www.stevns.dk > Vallø-Stevns fusion: > www.valloe-stevns.dk > * Tlf.: 5656 1891 > * Mob.:2895 3034 > > > > -----Oprindelig meddelelse----- > Fra: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] vegne af Bill Thoen > Sendt: 23. januar 2006 23:20 > Til: [email protected] > Emne: Re: [MI-L] Number of fields > > > Paul Middleton writes: > > What is the limitations on the number of fields you can have in any one > > layer/table, if so what are they and does the version of MI make any > > difference. > > > In an old MapInfo Users guide, the Frequently Asked Questions section in > the Appendix says it's 255. But IMHO, if you ever get up to needing that > many fields in your table, you probably ought to re-examine your data > structure and ask your self if it's as normalized (from a DBMS point of > view) as it should be. > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > > > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.375 / Virus Database: 267.14.22/238 - Release Date: > 23/01/2006 _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
