RE: MI MB Determining the Base Table of a Query

[Jacques Paris]

Title: MB Determining the Base Table of a Query

Totally undocumented. A very pleasant discovery I made recently. If you use tableinfo(your_query_name, TAB_INFO_MAPPABLE_TABLE) (code 12 in the MBW) you get the name of the base table ot your query.

 

MB reference states that this code should return the name of the table containing graphical objects for a table resulting for a relational join. That is not the case, i.e. it does much more. It even works with queries based on tables that are NOT MAPPABLE.

 

Jacques Paris

e-mail                alternate
     [EMAIL PROTECTED]   [EMAIL PROTECTED]

paris PC Consult (mainly MapInfo app.)
     www.total.net/~rparis/gisproducts.htm

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Landis, Bill @ Phoenix
Sent: February 23, 2000 8:57 AM
To: MapInfo Mail List 1 (E-mail)
Subject: MI MB Determining the Base Table of a Query

Anyone know how to determine the base table of a query using MapBasic?  For example if Query3 is a selection of block groups from table BG1999, how do I determine that Query3 is based on table BG1999?

Thank you,

Bill Landis...