TBDEDataSet.Locate() oddity?

[Ronin441]

I've been having some oddness with TBDEDataSet.Locate().

If I set an index with IndexFieldNames, and then Locate on those fields (or on the first few of those fields), it's always good. But if I do a Locate on something which I do not have indexed, or on an index other than the current one, then some of my Locate's fail.

The help claims that Locate will use an index if one exists, and if one doesn't, it will use a Filter. And stepping through the code, this seems to be what is happening; but the Filter attempt seems to fail, and I don't know why.

I'm using Paradox tables in Delphi 5 Update Pack 1 under Win XP. -- Doug Burbidge mailto:dougburbidge@yahoo.com

http://home.iprimus.com.au/dougburbidge/

 

[StevenK]

It isn't a simple case of case-sensitivity here is it ?
An entry of 'FindMe' find not be found if you're running a 'Locate' for 'Findme' unless you use the appropriate location options.
Steve

 

[Ronin441]

Don't think so. Flipping through my code I see at least one case whe I've set loCaseInsensitive, and it still doesn't work.

And I've messed about with setting it as case sensitive, too, just in case, and that didn't work either, even though the requisite search is in fact matched on case and should therefore succeed even without loCaseInsensitive.

Speaking of which, I generate my secondary indeces using a SQL command CREATE INDEX indexname ON tablename (field, field). Is there a way to control whether the created index is case sensitive?
-- Doug Burbidge mailto:dougburbidge@yahoo.com

http://home.iprimus.com.au/dougburbidge/