| Uploader: | Malmaran |
| Date Added: | 22 August 2009 |
| File Size: | 30.89 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 75308 |
| Price: | Free* [*Free Regsitration Required] |
But i don't know how should i start coding and update my table in access using mapbasic.
How to create an ODBC connection to SQL server
Sign up using Facebook. MapBasic has a number of functions and statements that can be used to work with spatial databases: Once you got your tables open, you save the changes back to the database via the Commit Table Statement. Thanks Peter, this was well explained. Now the integer variable nConnection holds the ID of the connection that you just opened to your database.
I already created an ODBC data source manually. May i know if i have 3 tables to access do i have to create 3 ODBC connection? Oodbc you want to create a linked table, have a look at Server Link Table statement. When working with any database from MapInfo Pro thru MapBasic you need to first establish a connection to the database.
I could make it manually and able to have a link between my tables to work on. Sign up or log in Sign up using Google.
How to create an ODBC connection to SQL server
Post Your Answer Discard By clicking "Post Your Answer", you acknowledge that you have read our updated terms odcb serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Post as a guest Name. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.
This require a data soruce which I can understand you already have. Server Link Table Statement: But i mapindo know if i have to code it in ofbc to call my table in access and able to have a link between tables and have it update it.
Email Required, but never shown. MapBasic has a number of functions and statements that can be used to work with spatial databases:.
Home Questions Tags Users Maponfo. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.
To Refresh a table you use the Server Refresh statement. It's now time to start using this connection. I would like to create a tools that will open and link my tables in access and update it time to time when every time i change something on my mapinfo table.
MapInfo Pro and ODBC Data sources
If you want to create a live table use the Register Table statement. I would recommend always running a Refresh statement after committing changes. Sign up using Email and Password.
Comments
Post a Comment