Sorting and searching in diffrent fields?

and...@kuai.se (Andreas Oestlund)

Delphi Developer

Mon, 02 Nov 1998 03:00:00 GMT

Sorting and searching in diffrent fields?

Hi!

I'm working on a application where I need to sort the data in a DBGrid

by one field, and searching on another.
The sorting is not so hard, just assigning an index to the indexname
prop.
But what about the searching... the app keeps searching on the field
I'm sorting by...

Please help!

/Andreas...

Andreas Oestlu

Delphi Developer

Sat, 07 Nov 1998 03:00:00 GMT

Re:Sorting and searching in diffrent fields?

Hi!

I'm working on a application where I need to sort the data in a DBGrid

by one field, and searching on another.
The sorting is not so hard, just assigning an index to the indexname
prop.
But what about the searching... the app keeps searching on the field
I'm sorting by...

Please help!

/Andreas...

Arro

Delphi Developer

Thu, 12 Nov 1998 03:00:00 GMT

Re:Sorting and searching in diffrent fields?

In <4nt4l3$...@kaon.kuai.se> and...@kuai.se (Andreas Oestlund) writes:

Quote

>Hi!

>I'm working on a application where I need to sort the data in a DBGrid

>by one field, and searching on another.
>The sorting is not so hard, just assigning an index to the indexname
>prop.
>But what about the searching... the app keeps searching on the field
>I'm sorting by...

>Please help!

>/Andreas...

When you sort on a certain index that index is active. When you search
on an index THAT index is active you can not have two indexes active at
the same time. The way around this is to search on secondary tTable
then do a findkey on the first table based on the first table index
field value of the second table. This should be very straightforward.
Say account number is active in the first table. You want to search on
the customer name. You open a second tTable for the same file.

Table2.IndexFieldNames := 'CustName';
Table2.Findkey([Edit2.Text]);
Table1.Findkey([Table2.CustNo]);

To the best of my knowledge that is the only method outside of tQuery.

Ben
Arrow

Other Threads

1. Sorting and Searching a lookup field

2. REQ: Diffrent star field?

3. Sorting A String Grid with a secondary sort field

4. TTable-Sorting with Lookup-Fields as Sorting Index????

5. Accented characters in search field / soundex search

6. Pdox ?: Sorting on a alpha field as if it were an integer field

7. searching text fields for partial matches anywhere in field

8. Index Search + Quick Sort

9. SQL searching/sorting problem with Interbase v4

10. Searching and Sorting in Delphi