active table search

[BB_Herman]

I am trying to emulate the pop-up box in outlook for the global address list.  Some functionality I'm looking for is while the user begins to type in the last name, the table scrolls automatically up or down displaying the names accordingly.  I have a table with lastname, firstname, initial, email.  I can do a search on the lastname, but I want the names to be actively displayed (table scrolling up and down), then the user can just select the name he wants.  I'm trying to eliminate the user having to type in the entire last name in order to find the correct email address.

In simpler terms, I would like the same functionality as the pop-up window in outlook.

Any suggestions is appreciated.  Thanks.

LV 8.5.1, WinXP Pro

[SanRac]

HI

Search the element in the table and find out the row index which you want to point out.

Using porperty "Index Values" of table you can assign the top left corner, in this you can mention your row number that automatically scrolls the table as shows your record on the top.

Hope this helps

Regards

Santosh

[StephenB]

Santosh is on the right track. Additionally, you are going to want to right click your string control and select 'update value while typing'

[BB_Herman]

Guys, thanks to this point.  I understand how to scroll the table.  Now, how do I perform the search.  I have code that will perform the search if the entire name is entered.  How would you do a piecemeal search?  For example if the last name is Smith, I would like to be able to type s, have the table scroll to the beginning of s, then type m, have the table scroll to sm and so on.

[SanRac]

HI

I dont know the exact methond but you can use the following technique

First make sure you have sorted the data, then take an coloum you are searching

When Search element value changes (when you type anything for search), read the size of string

Reshape all the elements of your coloum array to that size and

simply find out the index by searching in that coloum array

Does this make sense?

Regards

Santosh

[Hesloppy]

Hi BB Herman,

You could use an event structure that triggers on the value change event.  Put your search code in the event structure.  If you set the control on the front panel to update value while typing it will do your search every time you type a letter.

Best Regards, 

[BB_Herman]

Thanks for everybody's help.  With everyone's suggestions, I was able to put some code together and have a working prototype.  Attached is an image of the block diagram.

Thanks again.