And another often seen problem is the missing primary index in the server table. Make sure that you have a single integer column specified as the primary index.
If you are opening the table using a view this column should be named "MI_PRINX". This is the way to notifying MapInfo that this is the primary index column 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/gis Har du husket MapInfo Konferencen d. 8 og 9. september 2004. Tilmelding samt yderligere information kan ses p�: http://www.cowi.dk/GIS -----Original Message----- From: Robert Crossley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 2:45 AM To: MapInfo List Subject: Re: MI-L Can't edit tables from SQL Server We had this issue recently. It seems that when you create a table using the upload tool, it can set your character fields as Char fields in SQL. We found this problem and fixed it by changing the field type in SQL to nvarchars, and then relinked, and it worked fine. r On Tue, 7 Sep 2004 17:24:26 -0600 (MDT), Bill Thoen <[EMAIL PROTECTED]> wrote: > I'm just forwarding this for Jorge who is having difficulty > subscribing > to > the list. Please respond to the list or to him directly. > > > ---------- Forwarded message ---------- > Date: Tue, 7 Sep 2004 17:58:37 -0500 > From: Jorge Cordero <[EMAIL PROTECTED]> > >> I have a connection to database of SQL Server 6.5 and MapInfo 7.0 My >> problem is that all the tables that in the database them I can >> download in mode (linked table) then all the operations that I do in >> MI refresh to the database >> >> But when I create a table to that data base and I want it to download >> to mapinfo the error displays is : "The table you have downloaded can >> not be edited. See MapInfo User's Guide for more information" >> >> the table is downloaded and no is editable >> >> What I can do the table is editable? >> >> >> Thank You >> >> Sorry but my english is bad :( >> > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 13242 > -- Robert Crossley Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA 153.549004 E 28.517344 S P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13243 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13262
