You need to add a return character yourself. Change:
put mGetSelection(gTable, "LITERAL", 1, mSelectCount(gTable), ",
", return, "DESCRIPT") after field "RegionSelectedGeographies"
to:
put mGetSelection(gTable, "LITERAL", 1, mSelectCount(gTable), ",
", return, "DESCRIPT") & RETURN after field
"RegionSelectedGeographies"
Irv
At 11:45 AM -0400 7/31/01, Gene Fritzinger wrote:
>Thanx Irv,
>This now works with only one small problem. When it loops from 2 to
>4 and then 4 to 7, it doesn't add a return in the field so the field
>displaying the results looks like this:
>
><SNIP> from field member
>
>New York Region
>New England Region
>Mid-Atlantic Region
>Great Lakes Region North
>Region
>West Region
>Northwest Region Military Region
>
><END SNIP>
>
>North Region (which is the first value of 4) should appear above
>West Region, and Military Region (which is the first value of 7)
>should appear below Northwest Region.
>Any ideas??
>
>Thanks again,
>g fritzinger
>
>-----------------------------------------------------------------
>I guessing that you want:
>
> repeat with var in gGeokeyList
> mSetCriteria(gTable, "PARENT01", "=", var)
>
>Given gGeokeyList of [2, 4, 7], the above will loop three times, with
>var getting the values of 2, 4, and 7. The way you had it, you were
>indexing into gGeokeyList twice.
>
>Irv
>
>
>At 9:19 AM -0400 7/31/01, Gene Fritzinger wrote:
>>Hello List,
>>I'm trying to set mSetCriteria from a list named gGeokeyList from
>>within a repeat loop. An example of what the list might look like is
>>[2, 5, 7]. I comment the line at which I get an "Index out of range"
>>error. Can anyone see what I'm doing incorrectly?
>>
>>on mouseUp
>> closeTables
>> closeDB
>> set gDB = 0
>> set gTable = 0
>> set gDB = new(XTRA "V12dbe", the moviePath & "GEO.v12",
>>"ReadWrite", "top secret")
>> CheckV12Error()
>> set gTable = new(Xtra "V12table", mGetRef(gDB), "regmast")
>> CheckV12Error()
>> repeat with var in gGeokeyList
>> x = gGeokeyList[var] --THIS IS WHERE I GET AN "INDEX OUT OF
>>RANGE" ERROR
>> mSetCriteria(gTable, "PARENT01", "=", x)
>> mOrderBy(gTable, "PARENT01")
>> mSelect(gTable)
>> put mGetSelection(gTable, "LITERAL", 1, mSelectCount(gTable), ",
>>", return, "DESCRIPT") after field "RegionSelectedGeographies"
>> end repeat
>>
>> go to "RegionPop"
>> updatestage
>>end
>>
>>Thanx in advance,
>>g fritzinger
>
>
>[To remove yourself from this list, or to change to digest mode, go to
>http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list,
>email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED])
>Lingo-L is for learning and helping with programming Lingo. Thanks!]
--
Lingo / Director / Shockwave development for all occasions.
(Home-made Lingo cooked up fresh every day just for you.)
[To remove yourself from this list, or to change to digest mode, go to
http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list,
email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED])
Lingo-L is for learning and helping with programming Lingo. Thanks!]
