MapInfo Pro

Is there a way to make these tables base tables, without having to save as, close and open the two tables?

Hi Sean,

Thanks for posting. Can you please clarify your use of "dynamic tables"? Are these SQL Queries created in MapInfo Pro? or are they "Views" that are opened via ODBC or DBMS ?

If so, there is no way to join those tables without saving them as base tables. In attempt to do so, typically returns the error "you can only perform dynamic joins on base tables" is that the error you are receiving?

If that is not your scenario , please clarify.

We did a quick test in MapInfo where we tried to join a query that generated the expect error.

Sean, are you looking for MapBasic code to save and open the dynamic tables as base tables?

Thanks Matt,

I used SQL queries (using Mapbasic) to create the two tables.

I used the following mapbasic code to save and open the dynamic tables as base tables, but I am not sure that this is the most efficient way (if there is a more efficient way, It would be great if you could supply a sample)

Commit Table Find_Grid As "E:\MapInfo\GIS analysis\2017_09 September MapBasic\Find_Grid.TAB" TYPE NATIVE Charset "WindowsLatin1" Interactive

Commit Table Buildings_Grid As "E:\MapInfo\GIS analysis\2017_09 September MapBasic\Buildings_Grid.TAB" TYPE NATIVE Charset "WindowsLatin1" Interactive

Close Table Find_Grid Interactive

Close Table Buildings_Grid Interactive

Open Table "E:\MapInfo\GIS analysis\2017_09 September MapBasic\Buildings_Grid.TAB" Interactive

Open Table "E:\MapInfo\GIS analysis\2017_09 September MapBasic\Find_Grid.TAB" Interactive

Sean :)

?

Sean,

Thanks for the quick reply! I am not aware of a more efficient method as you described. I am happy touch base with Engineering and confirm that there is no more efficient method than what you described.