MapInfo Pro 23 – Table Read-Only Error when Updating Object Styles via Joined Table (Regression from Older Versions)

[Ashutosh Kumar]

Hi,

Issue Summary:
I am attempting to update the object styles of a point table (POITAB) using style parameters (font, size, color, file name) stored in a reference style table (POISTYLE).

• POITAB (Point data) is fully editable (Read/Write).
• POISTYLE (Style definitions) is a read-only reference table.

The Problem:
When joining these two tables on their matching key columns (ETR_CRY to MSTR_CODE and SUB_CRY to MISTR_SUBCOD) into a temporary query table (Temp1), MapInfo Pro 23 implicitly locks the entire query output as read-only.

Because one of the parent source tables is read-only, running the following spatial update statement fails with an "Error: Temp1 is readonly" restriction:

sql

Select poitab.obj from POITAB, POISTYLE where POITAB. ETR_CRY-POISTYLE MSTR_CODE and POITAB SUB CRY-POISTYLE MIR SUBCOD into Templ NoSelect

Update Temp1 SET obj = Setobjectstyle(obj, FONT, SYMBOL_SIZE, COLOR_CDE, SYMBOL_CDE, FILE_NAME)

Important Context:

This exact code worked completely fine ,fast and perfect in previous versions of MapInfo Pro. The software used to allow editing on the editable components of a query join, but version 23 appears to strictly lock down the query table if any part of the join is read-only Tables You Cannot Update.

Goal:
I need a clean workaround or fix to bypass this version-specific join restriction As it work fast .so I can safely update the editable point geometries using the read-only reference data.

Thanks