Table Join - Unknown name

georeference.org

Home - General / All posts - Table Join - Unknown name

RAR121 post(s)

#02-Sep-25 21:47

I am running Manifold 9 Build 9.0.181.0 on windows 11.

I noticed that if I make a table join, click setup Join and Edit Query and run it from that Command, it works fine.

When I click Edit - Save as Query and run it later, it does not work and throws an error like 't.xxx': Unknown name.

Did anybody has the same issue and how can we solve this please?

Thank you for your help.

RAR

Sloots

717 post(s)

#03-Sep-25 13:29

It’s possible that the query was saved earlier, but the table you’re trying to update was recreated afterwards. The query expects a field named

xxx

where it can store the result of the join. When you click 'Initialize and edit query', that field is created automatically. However, if you run the query on a version of the table that doesn’t contain this field, you can expect an error to occur.

http://www.mppng.nl/manifold/pointlabeler

RAR121 post(s)

#03-Sep-25 14:51

Sloots,

Thank you so much for helping.

I am attaching this test map for you to look at if you have time please.

I run the query and worked fine.

I then deleted the added field an tried to run the query again but got the error.

Thank you so much for your help!

RAR

Attachments:
TEST_JOIN_TABLES.map

RAR121 post(s)

#03-Sep-25 14:58

Sloots,

I see what you meant: I added the field in Drawing Table before running the query and it worked fine.

Does this mean that we cannot save and re-run the query from Join and have always to do that everytime manually?

Is there a way to get around that please?

Thank you Sloots!

RAR