Bev, You seem to be fairly proficient with the tools, so I will be vague.
You need a way of putting a key from your text data into the points table. First if you add a field in the text data and update this with rowid, and perhaps another with the text from the object. You could even convert the object to a point as well (Optional). Update TextTable Set RowFld = ROwID Update TaxtTable Set TextUsed = objectinfo(texttable.obj,3) Update TextTable Set Obj = CreatePoint(CentroidX(Obj), CentroidY(Obj)) Then perhaps use the find nearest point techniques that have been discussed previously in the list to set the rowID in the points table, or you could use your buffers and make them sequencially larger, but only updating the a selection from the points table that haven't been updated before (select from the pointstable where RowFld = 0 into UpdateSet and update this selection rather than the points table). To do this you could update the object in the points table with a buffer, and join it to the text table with a standard within clause. > Hi all, > Forgive my flattened forehead.I've spent the better part of > half a day trying to do something I thought was going to be relatively > simple. > I have two tables. One a 3000+ point object table and the other a like > amount of text objects. The text objects are all whole numbers and > relate to the nearest point object. What I want to do is update a > column in the point table with the text from the text table for the > corresponding point. Unfortunately, there is not a one to one > relationship between point and text i.e.: the 6th row in the point > table doesn't necessarily equal the 6th row in the text table so I can't > use rowid to join them. I've tried setting a 3 meter buffer for all the > point objects and using the "object from the text table is within the > object from the point table" and using the expression > "val(str$(objectinfo(texttable.obj,3)))" for updating my integer column > in the point table .Didn't work, I afraid! > I don't have anything in common between the two tables that I can use to > join them. > Anybody have any hints? > > Thanks in advance, > Dan Donnell > NGA > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18046
