FindNearest doesn't work

[tobenschain 0]

I can't understand why this doesn't work

 

Using FireDAC with SQLite and  TFDTable, this returns RecNo of -1

findkeyw := '8F';
ABudSys_DB.IndexFieldNames := 'key';
ABudSys_DB.IndexName := 'KeyIdx';
ABudSys_DB.FindNearest([findkeyw]);

This also returns RecNo of -1

findkeyw := '8F30';
ABudSys_DB.IndexFieldNames := 'key';
ABudSys_DB.IndexName := 'KeyIdx';
if ABudSys_DB.FindKey([findkeyw]) then

File has for index

8A43
8F30
8F31

[tobenschain 0]

BudSys_DB.Params.RecordCountMode := cmTotal;

 

doesn't help 

 

 

[Uwe Raabe 1891]

Can you list the following settings for the TFDTable instance:

• CachedUpdates
• FetchOptions.Unidirectional
• FetchOptions.CursorKind
• FetchOptions.LiveWindowParanoic

Also, is KeyIdx a primary or unique key?

[tobenschain 0]

CachedUpdates                              false
FetchOptions.Unidirectional           false
FetchOptions.CursorKind                ckAutomatic
FetchOptions.LiveWindowParanoic false
 

[tobenschain 0]

KeyIdx is primary and unique 

 

other settings:

 

[Uwe Raabe 1891]

Try setting FetchOptions.LiveWindowParanoic to True.

[tobenschain 0]

good to go

thanks