RE: MI MB Determining the Base Table of a Query

2000-02-28 Thread Thomas Brix Lyng 


Hi Jacques and Bill

Why not use SelectionInfo(SEL_INFO_TABLENAME)? Ofcouse you will have to
select at least on record in your Query first.

Regards

Thomas Brix Lyng
Frederikshavn Municipal Administration
Denmark

--
Fra: Jacques Paris[SMTP:[EMAIL PROTECTED]]
Sendt:  28. februar 2000 15:30
Til:  [EMAIL PROTECTED]
Emne:  RE: MI 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-mailalternate
 [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... 


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

RE: MI MB Determining the Base Table of a Query

2000-02-28 Thread 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 
Parise-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 @ PhoenixSent: February 23, 2000 8:57 
  AMTo: 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...

MI MB Determining the Base Table of a Query

2000-02-27 Thread Landis, Bill @ Phoenix 
Title: 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...