Let me give you a good example of a view table. I have a client that manages a large database of lease information on a mainframe type computer and is continually modifying the data by adding/deleting records. It has to be accessed through ODBC link. It is not capable of managing Mapinfo objects. If I brought the table over and created objects directly to ODBC table and they "insert" or "delete" a record into database, The objects I have creates will not coincide with the database and will thus be corrupted. Since each record of lease database has a unique number, I created an object table that only contains the link number and related object If I created a view linking the two databases together by the unique link number (essentially I would be creating a TAB file that contains the view information or logical link), every time I opened the view table it would automatically correlate the correct object with the correct database record. It also checks to see if the odbc table contains records that don't have an object associated with it, creates a empty record in the object table and allows me to search for all without objects and lets me create one. To me, this is another way of simulating the Spatialware with databases that are not supported. In order for me to provide my client with a easy method of managing views of other databases, I created a utility that asks you to define the name of the two tables, the linking field and the name of the new view table. If there is some interested in obtaining utility, let me know. Jacques Paris wrote: > 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.
begin:vcard n:Howard;Jerry tel;cell:318-426-1025 tel;work:903-633-2614 x-mozilla-html:TRUE url:www.micro-app.com org:Micro Applications Corp. adr:;;1361 Don Long Rd;Waskom;Tx;75692;USA version:2.1 email;internet:[EMAIL PROTECTED] title:President note:"Limited Only by Your Imagination" fn:Jerry Howard end:vcard
