Subject | RE: [IBO] IB_Grid SearchKeyByKey |
---|---|
Author | Alan McDonald |
Post date | 2007-11-20T00:55:29Z |
> Make sure you setup the OrderingItems and OrderingLinksFWIW - I've switched away from inc searching in the grid and swapped to the
> properties such that you use the POS attribute in the
> OrderingLinks property. This tells what character position
> the incremental searching should kick in at.
>
> So, for example, if you had a column ordered by last name
> this is how it should look:
>
> OrderingItems:
> NAME=MyTbl.LastName;MyTbl.LastName DESC
>
> OrderingLinks:
> MyTbl.LastName=ITEM=1;POS=3
>
> What you will have is upon the third character typed the
> incremental searching will begin. This is because it is
> going to automatically refresh the underlying query to start
> fetching records that are STARTING WITH those first three
> characters and then it will buffer up records as the 4th and
> subsequent characters are pressed.
>
> If you are searching for something with less than 3
> characters ENTER should go ahead and have it perform the
> search using what you have entered so far as an override.
>
> I have not exhaustively tested how well the incremental
> searching has been integrated into TIB_Grid so I would like
> to have you make sure to try using a separate TIB_IncSearch
> control as you learn and acquaint yourself with IBO's
> capabilities and then we can more clearly distinguish if
> there are issues with how the grid directly intereacts with
> the incremental searching stuff.
>
> Also, if you have columns that are integers, hitting return
> should do an exact match for the number entered. If you have
> numeric ID's that are all the same digits then you can set
> the POS attribute to that amount so that when an integer is
> entered it will perform the search once all digits have been entered.
>
> Hope this helps.
>
> Jason
IncSearch component. The grid searching is very slow because it pulls all
the rows across to locate the record. The IncSearch does a re-query based on
the search key which means it re-queries only enough rows to re-fill the
grid buffer.
Alan