Greetings and thanks for another problem solved,

The problem:  I'd like to use something similar to the Alias variable to
use the Map command with a variable number of tables and the Create Table
command with a variable number of columns.

The solution:  I followed the advice of Jacques Paris and it worked
beautifully:

====================================================
Simply use the run command solution. For the map it could be

RUN COMMAND "Map From "+StrTable_list

as long as you respect the proper spacing (after from) and commas (in the
list)..
====================================================

Trey Pattillo provided some further advice in consructing the strings:

====================================================
The thing that most often causes problems which I spotted instantly,
been-there-more-than-once, is building your string.  Use print or
note/msgbox statements to view it with the *run command* commented out
often
helps.

When you strTable_List is done it will read    ,table1,table2    with a
leading comma
It doesn't matter which way you construct a *looped* string you will have
either a leading or trailing comma
left over.

In you case, after the loop use
strTable_List=mid$(strTable_List,2,len(strTable_List)) to remove the comma.
====================================================

Of course, I immediately looked up the "Run Command" statement in the
reference book.  Interestingly, the example given is exactly what I was
trying to do!  But, unless you know it exists, I'm not sure how you would
bump into it.  I'm still on a steep learning curve for MB, and finding
"secrets" like the Run Command statement and the Alias variable are like
finding gold!

Thanks again and good luck,
Steve Riese

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

Reply via email to