Peter, and all of you
You have come up with the only example of a view table I know, and of the
use of the "Create View" statement.
I have never seen it documented in the various books and files coming with
MI/MB. It is however a full fledge statement that can be used outside the
TAB header. I have accomplished the same "view" table directly from the
MapBasic window as I would have had while opening the "view".tab.
Would anyone have more doc about it, or more examples of its use? I am sure
that several will find opportunities to use it if it were more "accessible"
to all.
Jacques
Jacques PARIS
e-mail [EMAIL PROTECTED]
For MapInfo support, see the Paris PC Consult enr. site at
http://www.total.net/~rparis/gisproducts.htm
For MapBasic questions see the J.Paris site at
http://www.total.net/~jakesp/index.htm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Martin Hodder
(ntl)
Sent: November 2, 2000 8:49 AM
To: Doyle, Peter W; 'Mapinfo-L'
Subject: Re: MI-L What is a View table
Peter,
I think a view table is one that is based on a join between two other tables
but open as a tab file.
Here is an example:-
!Table
!Version100
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
If this is saved as roads.tab, then you can use File > open table to open it
Regards
Martin
----- Original Message -----
From: Doyle, Peter W <[EMAIL PROTECTED]>
To: 'Mapinfo-L' <[EMAIL PROTECTED]>
Sent: Wednesday, November 01, 2000 10:58 PM
Subject: MI-L What is a View table
> Greeting all,
>
> The following MapBasic statement TableInfo( table_id , TAB_INFO_TYPE)
> returns a number of results depending on the table type.
> One of the return types is TAB_TYPE_VIEW.
>
> The Mapbasic manual contains the following description for this table type
> "if table is actually a view; for example, StreetInfo tables are actually
> views"
>
> I can not find any other reference to tables of type "View"
>
> Can anybody enlighten me to what a view table is, and what is its
structure.
>
> Regards
>
> Peter Doyle
> TELSTRA
> NTG
> Global Connect
> OnAir Networks Queensland
> Geographical Information Systems & Mapping
> ' +61 7 34064304
> Email: [EMAIL PROTECTED]
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
