Problem with SQLScrollViewMultiselect

[billborric]

Hi,

Just starting with b4a, so taking the above and modifying for my needs.

My problem is that the standard SQLScrollViewMultiselect when a row is selected it is highlighted.

Since making a number of changes to my program the row is no longer being highlighted. It is being selected just not highlighted.

I have spent quite a bit if time stepping through the original code then through mine, but just can't pickup where the problem is.

Would really appreciate some help.

Thanks

 

[kickaha]

The problem is that you are calling SQLReadTable in Sub Activity_Create and also in Sub Activity_Resume, leading to two lots of labels overlaying each other on the Table panel.

You may not appreciate that Activity_Resume is called after Activity_Create.

 

[billborric]

Hi kickaha,

Thanks very much, that worked a charm

 

[klaus]

Hi billboric,

Did you have a look at this example SQLiteDB ?

Best regards.

 

[kickaha]

I suggest that you put a call to ClearAll at the start of SQLReadTable to ensure that Table has all its views cleared before populating it.