Hi, I think your basic problem is using intersect with polyline objects. 2 different polylines that snap at endnodes may also intersect. So here is my suggestion (untested):
1) Start by adding an ID field to both MasterTable and SubsetTable. Use value of rowid for instance. 2) Save a copy of the mastertable and open the copy. 3) Now create a very small buffer around all objects in the copy. Just update the table itself, so the polylines gets replaced by the buffers. 4) run an SQL: select copy.id,subset.id from copy,subset where subset.object enirely within copy.object You should now have a list of ID's that match together and can use that for transferring data. Check that there are not 2 subset ID's for any master ID. If you have that, you need a smaller buffer. If any of the objects has been updated too, this method will fail. Next time you hand out a subset of the street network, make sure there is an ID field, so the updates are easy to integrate back into the master. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "S�ren Lindqvist" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 13, 2003 1:36 PM Subject: SV: MI-L Uppdate value from tableB to tableA continues This is giving me headache, I changed SQL to: Select TableA.ColumnA, TableA.ColumnB, TableB.ColumnA, TableB.ColumnB from TableA, TableB where TableA.obj Intersects TableB.obj into New_Table The New_Table has now 4 columns (all columns Char (2)) I want the two last columns (that is from TableB) to update the two first columns (that is from TableA) If I use the following selection Update Columns: Update New_Table Set TAA = TBA, TAB = TBB ###TAA is TableA Column A etc.### The result is giving me the values, but not in right order as they are from TableB, for example if I have value 11,11 in a row in TableB it gives me 13,13 in TableA!!!!! Instead of doing an update it messes up all my data in the selection for TableA. What I'm doing wrong? I have a "master" road network and got a part of it in another layer with updates that I need to transfer over to the "master". I thought by doing intersect you can then take the data from the update layer down to the "master" layer. Is this not the right way to do it? Any help is appreciated as I can't go any further just now. Thanks Regards S�ren -----Ursprungligt meddelande----- Fr�n: S�ren Lindqvist [mailto:[EMAIL PROTECTED] Skickat: den 13 september 2003 00:11 Till: [EMAIL PROTECTED] �mne: MI-L Uppdate value from tableB to tableA Dear list, I have two tables where one is updated (tableB). I need to update the data from tableB to tableA I have made two selections by SQL like this: Select * From TableA, TableB where TableA.obj Intersects TableB.obj into tmptA Select * From TableB, TableA where TableB.obj Intersects TableA.obj into tmptB Now I need to update columns "B" and "C" in tmptA with values from columns "B" and "C" in tmptB. How is it written? Update tmptA column B and C with values from tmptB columns B and C Regards S�ren --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8373 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8374 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8375
