I wrote:

>[1] I looked at the source for TIBODataset.SetKeyFields, and ISTM that the

first

>FindField call in GetIndex would always fail, because the field name in

tmpStr

>would always be the fully qualified field name (e.g., 'ARINV."Acc ID" '),

whereas

>the FieldName members are always unqualified and without quoting (e.g.,

'Acc ID').

>I added some code to strip the table name and any quotes, and that seemed

to

>work, but then I got the other error ("Field 'Acc ID' is not indexed and

cannot be

>modified.") so I removed the changes and worked around calling FindNearest

by

>using Locate instead.

It seems that "Not indexed and cannot be modified" has the same root cause,
that
is, that the string 'Acc ID' is being used to search the list of indexed
fields maintained
by the internal dataset, which has them listed as 'ARINV."Acc ID" ', etc.
The search
appears to try to account for removing ARINV., but can't cope with the
quotes.


Michael D. Spence
Mockingbird Data Systems, Inc.


[Non-text portions of this message have been removed]