Hi -

I am trying to create a lookup table using an array of values, as described in Appendix 2 of the Programming Guide.

When I test the program, everything appears ok; however, when I try it in preview mode, I get the message "[b]Array index overflow.[/b]"

Here's the programming I am using in global code:

[code]
stat LU1 as array[169,2] of String

LU1[1,1]="Air-Fresheners";LU1[1,2]="12"
LU1[2,1]="Aluminum-Foil";LU1[2,2]="11"
  etc for
LU1[3,1]
 through
LU1[167,1]
LU1[168,1]="Wines";LU1[168,2]="18"
LU1[169,1]="Yeast";LU1[169,2]="5"
[/code]

And here's the programming I am using in Category::On Element Exit

[code]
var i as Int
var foundit as String

If Category <> "" Then
{
For i = 1 to 169
If LU1[i,1] = Category Then
{
Aisle = LU1[i,2]
foundit = "yes"
i = 169
Throwfocus(Qty)
}


Next
If foundit <> "yes" Then
{
@Msgbox("'" + Category + "' not found in table.","","")
Clear(Category)
Goto Category
}
}

[/code]

So [b][i]now[/i][/b] where am I going wrong?

I would love to get this done before I go to sleep tonight, and I'm ready to go to sleep. So, if anyone is out there with a "solution," I would appreciate hearing from you.

Also, if there is an alternative approach that you think would be better in this situation, I would like to hear it.

Thanks!

Ray -

I'm a little confused.  If I comment out all of the Category::On Element Exit programming then how could my lookup possibly work?

When you say that you "tried the code and do not get an error" do you mean that you actually performed a lookup in preview mode?

Once again, when I test the programming - it clears just fine.  It is only when I actually try to perform a lookup in Preview Mode that I get the "Array Index Overflow" message.  That is followed, by the way, by a message that says "Error:  A runtime SBASIC error has occured.  Please close this form and repair the condition before continuing."

Unrelated programming that I have in the data base, does not run either.

I even went ahead and "reconciled" my dsr file to the db file and tested the db file.  I get the same message.

In any event, I did as you suggested and commented out the Category::On Element Exit programming and it made no difference.  Once again, the program test passed; however when testing the database in preview mode, I received the same two messages.

While I am waiting to hear from you, I will try to look at the 169 entries to be sure they are accurate (oh vey!  what a tedious task).  lol  

Ray -

You're a genius!

I found 3 types of errors:

(1) a "mismatch" such as you described, something like:

LU1[468,1]="Wines";LU1[168,2]="18"

(2) a duplicate entry, something like

LU1[12,1="Produce";[LU1[12,2]="33"
 ... and waay, waay down
LU1[12,1="Greeting Cards";[LU1[12,2]="44"

What happened is that I simply "dropped" the zero when I got to my 120th entry.

(3) a reversed code, something like:

I had listed LU1[122,1="Bags";[LU1[2,122]="13"

Having discovered this, is this not something that could be built into the "programming test" to save us an awful lot of trouble utilizing this type of lookup?

Lastly, given the tedious work in setting this up, would you recommend an alternative lookup for this many (169) required entries?  And, if so, what do you think would be my best choice (since there are several).

Thanks!

P.S.  Just as I posted this, your last message was posted, right when I was doing my "save" of my message.   lol

Quote:


No, all values (including array indexes) are not "realized" until runtime. SBasic is a compiled language.

Hi -

Grrr!  I cannot believe that I am back in this same thread (and so soon at that).  Just when I thought I had everything under control another problem has cropped up.

The following entries are coming out on separate lines in my combo box and, therefore, the lookup will not work.

LU1[93,1]="Jams, Jellies";LU1[93,2]="13"
LU1[94,1]="Jello, Pudding";LU1[94,2]="9" 

In my combo box, Jams and Jellies are appearing as two separate entries.  I can only select one or the other; however, the lookup fails.

If I type (in the combo box) Jams, Jellies, the entry is accepted and the appropriate lookup is completed.

Come on, now, this just CAN'T be me.  It just CAN'T BE!!!!

Help!!!

Mark,

I'm confused again since I provided the code above and it does include semicolons. Perhaps the code format made it difficult to see so here, once again, are the two line items I gave as an example.

LU1[93,1]="Jams, Jellies";LU1[93,2]="13"
LU1[94,1]="Jello, Pudding";LU1[94,2]="9"

I followed the programmers guide, appendix 2 very carefully when I started this.

Thanks!

Hi -

Spencer said:

[quote]Come on, now, this just CAN'T be me.  It just CAN'T BE!!!! [/quote]

Well, it [b][size=24]was too[/b][/size] Spencer and what we really need is a new icon depicting someone eating his or her own words!!!!     lol

I had so much difficulty with the global coding which was somewhat complex but simply more time-consuming (even though I used "Word" to manipulate data so that I didn't have to type each of those entries line by line) that I didn't give a whole lot of attention to my Category::On Element Entry coding. After all, that was fairly straightforward and I've done something similar many times.

[b][i]Yet[/i][/b] that is precisely where my problem was.  The global coding had (as shown above)

Jams, Jellies
Jello, Pudding

[b][i]But[/i][/b] the Category::On Element Entry coding had

Jams Jellies
Jello Pudding

Soooo Sesame did just what it was told - looked up the value of "Jams Jellies" or "Jello Pudding" and couldn't find it.

All I can say, is that I revealed several "pit-falls" in this little exercise and I hope it will prove to be of benefit to someone else.  I am determined to get this working, no matter what!

However, in the meantime, I have decided to add a database to the application and to use that database for the lookup.

Now for a little levity, after this torture,
 
[move][glb] HAPPY[/glb][i]... as you click on the messy looking link  below[/move][/i]

[url]http://www.msn.americangreetings.com/view.pd?i=382219626&m=1652&rr=y&s
[/url]

[move][glb]THANKSGIVING!!![/glb]
[/move]