DBISAM 3.3
Delphi 5

I have a table with a case-insensitive index called PLU that indexes
one field, PLU. When I set the .IndexName to 'PLU' and do a findKey it
does not locate the record even though the text does exist in the
table's PLU field. Any ideas why FindKey is not working?

___
Free Project Time Tracker for Delphi Developers
http://www.cyber-matrix.com/pcdelphi.html

Michael


Do you have a filter set?

Roy Lambert

On Thu, 29 Jun 2006 08:42:43 +0100, Roy Lambert
<roy.lambert@skynet.co.uk> wrote:

>Do you have a filter set?

No.

___
Free Project Time Tracker for Delphi Developers
http://www.cybermatrix.com/pcdelphi.html

Michael,

Is the value passed to FindKey an exact case-insensitive
match for what you are looking for? If your values are:


# PLU
- ---
1 AA
2 BB
3 CA
4 CB
5 CC

Assuming no filters, ranges, or OnFilter events, and
a case insensitive index is active on PLU:

FindKey(['C']) will not move the cursor
FindNearest(['C']) will move to record 3
FindKey(['CB']) will move to record 4
FindKey(['ca']) will move to record 3

Have you tried this in a test project with the only code
being to open the table and do a findkey? If you are using
findkey correctly and can duplicate the problem in a test
project, you can post both the project code & table to the
binaries newsgroup and maybe someone here can figure it out.
Also, verify the table to make sure you do not have a
corrupt index.


HTH,

Sean


Michael Fullerton wrote:
> DBISAM 3.3
> Delphi 5
>
> I have a table with a case-insensitive index called PLU that indexes
> one field, PLU. When I set the .IndexName to 'PLU' and do a findKey it
> does not locate the record even though the text does exist in the
> table's PLU field. Any ideas why FindKey is not working?
>
> ___
> Free Project Time Tracker for Delphi Developers
> http://www.cyber-matrix.com/pcdelphi.html

Michael,

<< I have a table with a case-insensitive index called PLU that indexes one
field, PLU. When I set the .IndexName to 'PLU' and do a findKey it does not
locate the record even though the text does exist in the table's PLU field.
Any ideas why FindKey is not working? >>

I would a) verify the table and then b) make sure that the text doesn't have
any odd spaces or characters in it that may be affecting the
indexing/searching.   Sometimes NULL characters get inserted into text and
they really screw up searching, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

On Thu, 29 Jun 2006 13:47:33 -0400, Sean McCall <NoSpam@nowhere.com>
wrote:

>Michael,
>
>Is the value passed to FindKey an exact case-insensitive
>match for what you are looking for? If your values are:
>
>
># PLU
>- ---
>1 AA
>2 BB
>3 CA
>4 CB
>5 CC
>
>Assuming no filters, ranges, or OnFilter events, and
>a case insensitive index is active on PLU:
>
>FindKey(['C']) will not move the cursor
>FindNearest(['C']) will move to record 3
>FindKey(['CB']) will move to record 4
>FindKey(['ca']) will move to record 3

I was basically trying to do:
FindKey(['c'])
but
FindKey(['C']) also did not work

When I use the full text (FindKey(['cb'])) it does work just fine.

>Have you tried this in a test project with the only code
>being to open the table and do a findkey? If you are using
>findkey correctly and can duplicate the problem in a test
>project, you can post both the project code & table to the
>binaries newsgroup and maybe someone here can figure it out.
>Also, verify the table to make sure you do not have a
>corrupt index.
>
>
>HTH,
>
>Sean
>
>
>Michael Fullerton wrote:
>> DBISAM 3.3
>> Delphi 5
>>
>> I have a table with a case-insensitive index called PLU that indexes
>> one field, PLU. When I set the .IndexName to 'PLU' and do a findKey it
>> does not locate the record even though the text does exist in the
>> table's PLU field. Any ideas why FindKey is not working?
>>
>> ___
>> Free Project Time Tracker for Delphi Developers
>> http://www.cyber-matrix.com/pcdelphi.html

___
Free Project Time Tracker for Delphi Developers
http://www.cybermatrix.com/pcdelphi.html

Tim


>I would a) verify the table and then b) make sure that the text doesn't have
>any odd spaces or characters in it that may be affecting the
>indexing/searching. Sometimes NULL characters get inserted into text and
>they really screw up searching, etc.

And don't forget control characters - invisible in normal controls

Roy Lambert

Sounds like what you want is FindNearest. FindKey is used to
find an exact match only.

Sean

> I was basically trying to do:
> FindKey(['c'])
> but
> FindKey(['C']) also did not work
>
> When I use the full text (FindKey(['cb'])) it does work just fine.
>