Solved

Need help with a component trying to use Lookup

Posted on 2006-07-12
2
195 Views
Last Modified: 2010-04-05
Ok,

I'm using Absolute DB (componentace.com) with a table that is setup in the following way:

------------------------------------------------------|
BLink | OLink | Option                       | PBCode|
------------------------------------------------------|
201   | 1001  | 'Integral Dust Drawer' | 'IDD'    |
------------------------------------------------------|

So, this is a price book table, with BLink(book link), OLink(option link) and a PBCode which is a string value, and option text.  

I have a combo box component that I'm trying to automatically fill with option text based on an array that is passed to it.  Here's the code that I build the combo box with:

Var
  modelArray: Array [0..2] of String;
Begin

    modelArray[0] := 'GSMBASE';
    modelArray[1] := 'HOPPER';
    modelArray[2] := 'IDD';

    //_Configuration is the combo box I'm trying to build....
    _Configuration.LoadItemsFromCodes(modelArray);

//Here's the code for the combo box.  It has properties of BLink and OLink, which are integer values.  So in this case the BLink is set to 201:

Function TPBxComboBox.LoadItemsFromCodes(codeArray: Array Of String): Integer;
Var
    i,daOLink: Integer;
     SearchList, SearchList2: Variant;
Begin
    Result := -1; // error code for NIL value for datasets
    ErrMsg := 'Nil Datasets';
    If Not Assigned(dsOptions) Then
        Exit;
    If Not Assigned(PItem) Then
        Exit;

    xOLinkTrack := False;

    For i := 0 To High(codeArray) Do
    Begin
        With dsOptions As TABSTable Do
        Begin
           
            If State = dsInactive Then
                Open;

            Self.Items.Clear;
            xOLinkList.Clear; //this is a string list that contains an olink for each item in the combo box

            //lookup the OLink for the PBCode that was passed via the codeArray[] array:
            daOLink := dsOptions.Lookup('BLink;PBCode', VarArrayOf([BLink,codeArray[i]]), 'OLink');

            Self.xOLinkList.Add(IntToStr(daOLink));
           
            //use the Olink we just found to lookup the Option text for placing in the combo box
            Items.Add(dsOptions.Lookup('BLink;OLink', VarArrayOf([BLink, daOLink]), 'Option'));

            Self.ItemIndex := 0;
            Result := Items.Count;

            //other various code....
            If Items.Count > 0 Then
            Begin
                xOLinkTrack := True;
                ziHold      := ihOptions;
                Self.Change;
            End;
        End;
    End;
End;

As you can see, this should find an olink for the each of the values that I pass to the LoadItemsFromCodes function, then use that olink to find the option text and load that text into the combo box.  However, it only puts the 'IDD' or Integral Dust Drawer option in.  The two other array values are simply not present in the combo box, even though they are present in the dsOptions table and should be in the combo box.  I cannot figure out why.  This is my first time using the Lookup method, so I may be missing something easy here.

Thanks!
0
Comment
Question by:light_bulb
2 Comments
 
LVL 3

Author Comment

by:light_bulb
ID: 17091334
Oh shoot, I found the problem.  I should have put the following lines before the loop instead of inside it:

Self.Items.Clear;
xOLinkList.Clear;

I was clearing the lists every time through the loop.  Oh well, not the first time I've made that mistake.
0
 
LVL 17

Accepted Solution

by:
Wim ten Brink earned 500 total points
ID: 17106729
Damn! I was about to say that too. :-)

You might want to put the line "If State = dsInactive Then Open;" also a bit higher, outside the loop. No need to check if it's inactive for every item in the array, is it? This will probably speed up your code with about 5 clock cycles, which on a 1 GHz computer will save you... Well, it's not much, I know...

Go ask for a refund and have this question deleted before someone else sees your mistake... ;-)

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now