My old notes may be faulty, but it seems that a while ago I was able to
use a "Create View" statement in a TAB file to join two tables. The
classic use for this is for buildng StreetInfo-like tables, where you have
one table with lots of line segments for each street and a street name
table that maintains a unique list of street names, and you link these
tables via a common key.
I created some street files from the latest TIGER data and when I use
Create View, the results are scrambled. Streets get all the wrong names.
However, when I join the tables normally, everything looks right. I'm
using MapInfo ver. 7.8. Why doesn't the Create View work? Am I doing it
wrong, or does it just not work any more? BTW, the MapBasic help file
doesn't have an entry for "Create View", but I could swear this is what
old StreetInfo files used to use!
Does anyone have any ideas about this? Here's the tab file contents:
COBOULDER.tab
-------------
!Table
!Version 300
Open Table "COBoulder1" Hide
Open Table "COBoulder2" Hide
Create View COBoulder As
Select Street,FromLeft,ToLeft,FromRight,ToRight,Class,TLID
>From COBoulder1, COBoulder2
Where COBoulder1.StreetId=COBoulder2.StreetId
COBOULDER1.tab
--------------
!table
!version 300
!charset WindowsLatin1
Definition Table
Type NATIVE Charset "WindowsLatin1"
Fields 7
FromLeft Integer ;
ToLeft Integer ;
FromRight Integer ;
ToRight Integer ;
Class Char (3) ;
TLID Integer ;
StreetId Integer Index 1 ;
COBOULDER2.tab
--------------
!table
!version 300
!charset WindowsLatin1
Definition Table
Type NATIVE Charset "WindowsLatin1"
Fields 2
StreetId Integer Index 1 ;
Street Char (40) Index 2 ;
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17250
