"Michael Yam" <[EMAIL PROTECTED]> wrote in message
news:45844@palm-dev-forum...
>
> If you have records marked deleted (vs. physically removed), you may get
an
> unexpected result. You can always sort your database, moving records
marked
> deleted to the bottom. That should fix the problem.
>
> Michael Yam
> www.ytechnology.com
>
>
Well, that wasn't the problem. The first string of my record is always a
combination of character and digits. Because I took the database from a
source that produces only numeric data, the database was not sorted in the
correct way ( numbers were sorted by value ). The string compare function
uses alphabetic order and therefore the returned value was not correct. A
simple sort fixed this annoying issue.
Regards, Michael
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
