[Base] Access2base 1.1.0 RemoveItem ABORT

[gonzolo]

Hi all,
I'm using the method RemoveItem provided in Access2base 1.1.0 to clear listbox items.

Code: Select all

olb.RemoveItem(olb.ListIndex)

But when we have only one item left in the list box, and we want to delete it (to have an empty listbox) the function nicely aborts with the following error message:

Error #9 (Index out of defined range) occurred at line 694 in Control.RemoveItem

This looks like to be a resizing error of the item array that goes negative...

Any fix for this? Is there a way to clear directly the listbox items?
thank you!

[MTP]

I suspect it's not possible to "delete" the last item in a listbox, maybe try instead replacing it with an empty string ("").
If you know from the start you're emptying the entire list, you can just replace the source array of the list box with an array of one item that holds an empty string; that would be quicker than removing the items one at a time.

[JPL]

Hello,

I'm the author of the bug ...
... and also of what sometimes works fine in Access2Base (?).

The concerned line in the software is

Code: Select all

ReDim Preserve vRowSource(0 To iCount - 1)

and this DOES NOT create an empty array when iCount = 0, as I maybe expected when I wrote this code.

I will prepare a patch that will be included, considering https://wiki.documentfoundation.org/ReleasePlan, probably in LO 4.3.7 and LO 4.4.1.
A correction has been pushed to LO 4.3.7 and LO 4.4.1. See https://wiki.documentfoundation.org/ReleasePlan for their availability.

Note that LO 4.4.0, which be was released recently in the next coming hours or days, will includes Access2Base 1.2.0. This is good news. Unfortunately it still includes above bug.

The workaround proposed by MTP looks smart to me, as soon as the control is not bound to a database field.

Sorry for the inconvenience.
Thanks for using Access2Base and helping me to make a better software.

JPL

[karolus]

LO4.4.0 is released since yesterday

[gonzolo]

Many thanks JPL for the bug fix and for the access2base extention. I think that's a very useful one.

Thanks also to MTP for his suggestion.

Keep coding, guys!

[MTP]

Thanks also to MTP for his her suggestion.

Fixed that for you
Glad you found help in this thread!