Given the data posted with the project, uploaded to Yahoo as IBO_indexes.rar (Delphi 10.3 Rio), we are facing two problems with IBO.

 

These problems are only replicable with IBO if we create a descending index in the DB.

There are no problems even with the descending index, when using FireDAC (so not a Firebird problem)

There are no problems with IBO when deleting the descending index.

 

Here are the aforementioned problems:

 

-   Alternating indexes causes the below error, using the following steps:

 

0)  Check the box to use IBO instead of FireDAC

1)  Activate the table

2)  Set the primary index

3)  Set the index to input date

4)  The resulting error: ISC code 335544569, malformed string

The error is not replicable with FireDAC components (repeat same steps without checking the box)

 

See error1.png in the uploaded folder

 

 

-   Enabling the inputdate index causes records to disappear in a first step, but then they re-appear after navigating the “first” and “last” buttons.

Note that clicking the first and last buttons gives different results, without changing the index

 

 

0)  Check the box to use IBO instead of FireDAC

1)  Activate the table

2)  Set the index to input date

3)  All the records disappear except this one

4)  Press first twice, the order of records is not consistent

5)  Press last twice, the order of records is also not consistent

 

See error2.png in the uploaded folder

Any idea what could be going wrong here?