I have a project which I am reviving after a gap of some years. It involves several hundred runs within MapInfo, scripted in MapBasic.
I am stuck at a point that is so simple, it's driving me nuts.
At one point within each run, I have six tables, each of a single cell.
These tables are called:
minBNGy maxBNGx minBNGy maxBNGy medBNGx medBNGy
They are min, max and median British National Grid coordinates. Each table is mappable, with a single point.
In each case, the table's single variable has the same name as the table.
Each is a long integer, but for some (probably deliberate) reason I no longer understand, I created these as floats.
I need to compile from these six tables a single table, with the six named cells and their values on a single row. It does not need to be mappable.
I was using this:
Add Column TARGET_TABLE (NEW_VARIABLE)From SOURCE_TABLE Set To SOURCE_VARIABLE Where COL1 = COL1
... but it no longer seems to work.
In my old code, the 'map' was dropped later.
I am using MapInfo / MapBasic v.6.5 on Windows 7 Ultimate 64-bit.
I would be very grateful for any guidance.