Update column error

[Bob]

I'm getting an error message "Unable to update table" when I do an
update column on a point table from another polygon table where it
contains that point. I've never had any problems with this before,
but now it just won't allow the column to be updated. Both columns in
the 2 tables are the same type (decimal 3,0) and I am using MI Pro
v9.5.

It did work if I save a copy of the point table, then update that
column, but the original point table has some deleted rows and when I
save a copy, it automatically removes all deleted rows, which is a
problem because I have this point table (cities) referenced in
hundreds of saved workspaces that would completely mess up the custom
labels.

If anyone seen anything like this before or know how to correct it, I
would appreciate any kind of help.

Thanks,
Bob

[Kent Treichel (MDOR)]

MapInfo will kick out that error as soon as it reaches a deleted row. "Save as" or packing the table will remove the error. One way to avoid either of those options is to update a query of the table where only undeleted records are present.

[ktg cad]

I used to get the same sort of problem when i use to update records from one file to another or frm one column to another...This happens most of the time due to table conflicts and mismatch in table selection..

 

But i follow a systematic way to do this and so far i haven't faced that problem..All my geological maps have this task to be done and i have no issues..

 

But in your case you say that all the fields and its table contents are same..may be as suggested try to

pack off the tables, so that all the deleted columns which leaves a deleted impression in the table gets fleshed out.. this way it work quite often...

 

Thanks

Ktg

[Driver, Greg 9434]

Bob,

As mentioned by Kent, the error is to do with the deleted rows you have
in your table. One work around would be to do an SQL select on your
points table, selecting those points with objects:

Select * from points_tab where obj into update_query

You can then use the query that this SQL select creates (update_query in
above example) in the update column process, rather than the original
points base table. As the query doesn't contain any 'deleted' rows, the
update should work without throwing an error (I've just tried it!).

HTH

Greg Driver

System Administrator
Applications Support
ICT
Surrey Police
NOT PROTECTIVELY MARKED

-----Original Message-----
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On
Behalf Of Bob
Sent: 03 December 2008 20:37
To: MapInfo-L
Subject: [MI-L] Update column error

I'm getting an error message "Unable to update table" when I do an
update column on a point table from another polygon table where it
contains that point. I've never had any problems with this before,
but now it just won't allow the column to be updated. Both columns in
the 2 tables are the same type (decimal 3,0) and I am using MI Pro
v9.5.

It did work if I save a copy of the point table, then update that
column, but the original point table has some deleted rows and when I
save a copy, it automatically removes all deleted rows, which is a
problem because I have this point table (cities) referenced in
hundreds of saved workspaces that would completely mess up the custom
labels.

If anyone seen anything like this before or know how to correct it, I
would appreciate any kind of help.

Thanks,
Bob

*Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks.*

[Rarkyan Nimrook]

Hi Bob, 

sorry for my bad english. Try to pack your data by select Table>maintenance>pack table> select pack both data, and save your file. Now reopen and update column again. Hope this help