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!]
