MapInfo Pro Developers User Group

Hi there,

I'm trying to rewrite some old MapBasic extensions with Python on MapInfo Pro 2023. In our old codes, below MapBasic commands played super important role and I'm trying to keep it that way (to keep it as a linked table out of PG). 

Hey Ferhad

pro.Catalog has this method, which may be what you are looking for:

OpenTable(IDataSource, TableDefinition)

Opens a table using the TableDefinition and IDataSource objects identified by the tableDef and dataSourceparameters. 

I often use pro.RunMapBasicCommandEx() to execute MapBasic code from Python. This generally works well, too.

You can't do everything directly through Python, so some things still require MapBasic code.

Hi there,

I'm trying to rewrite some old MapBasic extensions with Python on MapInfo Pro 2023. In our old codes, below MapBasic commands played super important role and I'm trying to keep it that way (to keep it as a linked table out of PG). 

Thank you so much Peter for the answer. I'm still trying hard to make it work. My question does involve opening the tables (your suggestions would perfectly work for that part) but it was more about downloading data (and saving as .tab files) from our PG server using python preferably. I can still try MapBasic way. It's just the interactions part between them is giving me a little hard time. 

Is there any way that I can retrieve the results from pro.RunMapBasicCommandEx()? For instance, is it possible to get the hdbc (the handle for odbc conneciton built by MapBasic function server_connect())? 

Would this work from Python side? 

hdbc = pro.RunMapBasicCommandEx("Server_Connect(connection parameters here)")

Hey Ferhad

pro.Catalog has this method, which may be what you are looking for:

OpenTable(IDataSource, TableDefinition)

Opens a table using the TableDefinition and IDataSource objects identified by the tableDef and dataSourceparameters. 

I often use pro.RunMapBasicCommandEx() to execute MapBasic code from Python. This generally works well, too.

You can't do everything directly through Python, so some things still require MapBasic code.

Hi there,

I'm trying to rewrite some old MapBasic extensions with Python on MapInfo Pro 2023. In our old codes, below MapBasic commands played super important role and I'm trying to keep it that way (to keep it as a linked table out of PG). 

Hey Ferhad

To call a MapBasic function from Python, you can use pro.EvalMapBasicCommandEx:

hdbc = pro.EvalMapBasicCommandEx("Server_Connect(connection parameters here)")

That will return the handle to the variable hdbc.

Thank you so much Peter for the answer. I'm still trying hard to make it work. My question does involve opening the tables (your suggestions would perfectly work for that part) but it was more about downloading data (and saving as .tab files) from our PG server using python preferably. I can still try MapBasic way. It's just the interactions part between them is giving me a little hard time. 

Is there any way that I can retrieve the results from pro.RunMapBasicCommandEx()? For instance, is it possible to get the hdbc (the handle for odbc conneciton built by MapBasic function server_connect())? 

Would this work from Python side? 

hdbc = pro.RunMapBasicCommandEx("Server_Connect(connection parameters here)")

Hey Ferhad

pro.Catalog has this method, which may be what you are looking for:

OpenTable(IDataSource, TableDefinition)

Opens a table using the TableDefinition and IDataSource objects identified by the tableDef and dataSourceparameters. 

I often use pro.RunMapBasicCommandEx() to execute MapBasic code from Python. This generally works well, too.

You can't do everything directly through Python, so some things still require MapBasic code.

Hi there,

I'm trying to rewrite some old MapBasic extensions with Python on MapInfo Pro 2023. In our old codes, below MapBasic commands played super important role and I'm trying to keep it that way (to keep it as a linked table out of PG).