Problem with DBase index files and Delphi (UPPER, STR, etc)

creal...@pi.net (Michael Parree)

Delphi Developer

Thu, 16 Apr 1998 02:00:00 GMT

Problem with DBase index files and Delphi (UPPER, STR, etc)

I use DBASE IV files as database files for a Delphi project. All
single field indexfiles work fine with my code. However if I use a
DBASE expression for an indexfile (like UPPER(NAME) or
STR(ORDERID)+STR(ITEMID)), everything seems to work fine until I use
the FindKey or FindNearest method. Whenever I try to find a particular
record I get an error 'Field Index out of range'.

Can anyone please give me some hints?

Thanks in advance!

Michael Parree
Cornerstone Reality
creal...@pi.net

Michael Parr

Delphi Developer

Thu, 16 Apr 1998 02:00:00 GMT

Re:Problem with DBase index files and Delphi (UPPER, STR, etc)

Sorry for posting the previous article. I found the answer by looking
into the FAQ. I have to use GotoKey or GotoNearest instead.

Thanks for reading!

Quote

creal...@pi.net (Michael Parree) wrote:
>I use DBASE IV files as database files for a Delphi project. All
>single field indexfiles work fine with my code. However if I use a
>DBASE expression for an indexfile (like UPPER(NAME) or
>STR(ORDERID)+STR(ITEMID)), everything seems to work fine until I use
>the FindKey or FindNearest method. Whenever I try to find a particular
>record I get an error 'Field Index out of range'.
>Can anyone please give me some hints?
>Thanks in advance!
>Michael Parree
>Cornerstone Reality
>creal...@pi.net

Other Threads

1. dBase index like UPPER(Name) in code

2. How-to create dBase index on Upper(Name) at Runtime

3. dBase Runtime housekeeping - create missing indexes, tables, etc

4. Parsing strings, str>numbers etc, FAQs

5. Parsing strings, str>numbers, etc FAQs

6. Problem with search in dbase index files

7. Problems with dBase index files

8. Index file problem for DBase

9. Problem reading dbase III files - corrupt table/index header

10. File/directory mapping problem under Win95 (upper/lowercase problem)