I have a pervasive 2000 db. In this db there is a table. I have run
into the following situation and would appreciate some help.

For the sake of simplification:

The table has three rows

The rows have keys of "A" "B" and "C"

If I do a query looking for the exact value of "B", the query returns
an empty found set.

If I do a query looking for everything > "A" and < "C", the query
returns a found set that includes the "B" record in question.

If I do a query looking for the exact value of "B" and everything >
"A" and < "C", I get an empty found set.

If I do a query looking for everything > "A" and <"C" and the exact
value of "B", I get the found set that includes the "B" record in
question.

If I do a query with no conditions, I get "A" "B" and "C" in the found
set.

The queries are run through ODBC and a delphi program, as well as ODBC
through Crystal Reports.

The index for the table has been rebuilt, but that did not resolve the
issue. Any ideas on what I might want to try next?

Tom Pietrzak

Check to see that your DDF definitions match the Btrieve definitions with
the Check Database Wizard in the PCC. Odds are good that they do not
match for this file.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


Tom Pietrzak wrote: