MapInfo Pro Developers User Group

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.

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.

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.