Re: MI ODBC link tables

2000-02-17 Thread Geografía y Electrónica, SA de CV

You need to create a view, similar to a StreetInfo table

create view MyView as select * from TableOdbc, TableMap where
TableOdbc.UniqueField = TableMap.UniqueField 

The process is very fast even with large tables.  Later, you can even
create a .tab file that opens as a regular mapinfo table.


At 05:51 a.m. 16/02/2000 PST, you wrote:
Hello

I'm using the OPEN ODBC TABLES function to link a table from ACCESS. It's 
working fine. This table is not a mappable table and it's ok. What we want 
to do is combine it with and existing mappable table in Mapinfo that as a 
common field with this ACCESS table so that we can create a new unique 
table. The result we are looking for is that when we ask info on an object 
in the Mapinfo table, it would give us the info in both table (ACCESS and 
MAPINFO). To have worked with Arcview, i know that was easy to combine table 
using a common field. It doesn't seem that easy in mapinfo. Any suggestion 
out there that doesn't involve to much programming.
__
Get Your Private, Free Email at http://www.hotmail.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

-
 Ing. Juan Pufleau Correa
Geografía y Electrónica, SA de CV
  Aguascalientes, Mexico
-
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI ODBC link tables

2000-02-16 Thread Daniel Groleau

Hello

I'm using the OPEN ODBC TABLES function to link a table from ACCESS. It's 
working fine. This table is not a mappable table and it's ok. What we want 
to do is combine it with and existing mappable table in Mapinfo that as a 
common field with this ACCESS table so that we can create a new unique 
table. The result we are looking for is that when we ask info on an object 
in the Mapinfo table, it would give us the info in both table (ACCESS and 
MAPINFO). To have worked with Arcview, i know that was easy to combine table 
using a common field. It doesn't seem that easy in mapinfo. Any suggestion 
out there that doesn't involve to much programming.
__
Get Your Private, Free Email at http://www.hotmail.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]