Board index » delphi » FindKey does not always find a record

FindKey does not always find a record

Hello everybody,

        I have a Delphi application that accesses an Interbase v3.3f
Server Database.  Occasionally, my application does a FindKey, but does not return the
data from the table.  I have made sure that the information in the FindKey statement
is correct for the index that I am using at the time of the FindKey.  The data that I
am looking up is in the Database.  I would estimate that 2-3% of the time this is the
FindKey
is not finding the record from the table.

        Why is this happening?  Any help would be greatly appreciated.

Thanx

Chad Lind
cal...@cacd.rockwell.com    

 

Re:FindKey does not always find a record


Check for non-visible characters that may be either in the actual
key values or in your search key (e.g., blanks).  Also, check the
key sizes.

Re:FindKey does not always find a record


In article <49i177$...@newssvr.cacd.rockwell.com> cal...@cacd.rockwell.com (CHAD A LIND) writes:

Quote
>From: cal...@cacd.rockwell.com (CHAD A LIND)
>Subject: FindKey does not always find a record
>Date: 29 Nov 1995 16:19:51 GMT
>        I have a Delphi application that accesses an Interbase v3.3f
>Server Database.  Occasionally, my application does a FindKey, but does not
>return the

[snip]

This is clearly a database question, but was also posted in "misc" and
"components".  Please be more discriminating in your choice of
groups.
==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==+==
Andrew Gabb                     a...@itd.dsto.gov.au
Information Technology Division
Defence Science and Technology Organisation
Ph  +61 8 259 5505    Fax +61 8 259 5980
171 Labs ITD/DSTO, P.O. Box 1500, Salisbury S.A., Australia 5108

Other Threads