Hi Christian!
This is a case where the command 'Create View' comes into use.
It's an obscure feature of MapInfo, little known but very handy.
Bill Thoen wrote a summary last year in july.
Search the archive for
| RE: MI-L Has the "Create View" statement been dropped? |
It's described in the MapBasic help file thus, with an example:
Creating a View Table
The example below is from a StreetPro TAB file for Delaware, NewCastle county. It performs a select statement from the view table by opening two other linked tables as hidden views to allow access to the attributes of those tables for geocoding, display, etc.
!Table
!Version 100
Open Table "denewcs1" Hide
Open Table "denewcs2" Hide
Create View denewcs as
Select Street,FromLeft,ToLeft,FromRight,ToRight,Class,Tiger_RefNum
>From denewcs2, denewcs1
Where denewcs2.MI_Refnum=denewcs1.MI_RefNum
Hope this helps.
Hälsning / Best regards Mats.E
________________________
FB Engineering AB
Södra Förstadsgatan 26
211 43 Malmö
Tel: 040-660 25 50
Mobil: 0705-27 60 27
Fax: 040-660 25 99
[EMAIL PROTECTED]
www.fbe.se
![Inactive hide details for "Christian McNierney" <[EMAIL PROTECTED]>](gif2yHcxKae0C.gif){kind=small}
"Christian McNierney" <[EMAIL PROTECTED]>
Sänt av: [EMAIL PROTECTED] 2006-03-15 15:57 |
|
I am trying to geocode a table within MapInfo and I am not having any luck. I am using ver 8.0 and I have two tables... one contains TIGER street files with columns for street name, FromRight, ToRight, FromLeft and ToLeft. The file I am trying to geocode has an address column with street number and name, city, state and ZIP. When I try to run the geocoding process, the only options I am getting are numbered street names like 59th St for and address like 5900 Main St.
The columns for FromRight, ToRight, FromLeft and ToLeft are of type integer.
Any suggestions?
TIA
Christian McNierney
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
