Android Question B4A B4XTable layout problem

bitben

bitben

Member
Licensed User
Longtime User
Hello community,

i have a little problem with B4XTable: its layout doesn't really update on pages after page 1.
B4X: 
Sub B4XTable1_DataUpdated
    
    For i = 0 To B4XTable1.VisibleRowIds.Size - 1
        Dim RowId(2) As Long
        RowId(0) = B4XTable1.VisibleRowIds.Get(i)
        If i > 0 Then RowId(1) = B4XTable1.VisibleRowIds.Get(i-1)
        If RowId(0) > 0 Then
                
            Dim xui As XUI
            Dim clr As Int = xui.Color_DarkGray
            Dim row As Map = B4XTable1.GetRow(RowId(0))

            For j = 2 To row.Size - 1
'                Dim p As B4XView = B4XTable1.GetColumn("Status").CellsLayouts.Get(RowId)
                If j <> 4 Then
                    Dim p(2) As B4XTableColumn
                    Dim pv(2) As B4XView
                    Try
                        p(0) = B4XTable1.Columns.Get(j)
                        pv(0) = p(0).CellsLayouts.Get(RowId(0))
                        
                        If i > 0 Then
                            p(1) = B4XTable1.Columns.Get(j)
                            pv(1) = p(1).CellsLayouts.Get(RowId(1))
                            
                            Dim tmp() As Double = Array As Double(pv(0).GetView(0).Text,pv(1).GetView(0).Text)
                            If tmp(0) > tmp(1) Then
                                clr = xui.Color_ARGB(255, 2, 179, 0)
                            Else If tmp(0) = tmp(1) Then
                                clr = xui.Color_DarkGray
                            Else If tmp(0) < tmp(1) Then
                                clr = xui.Color_Red
                            Else
                                clr = xui.Color_Magenta
                            End If
                        End If
                        
                        pv(0).GetView(0).TextColor = clr
                        
                        If row.Get("Status") = "UP" Then
                            pv(0).GetView(0).Color = xui.Color_ARGB(30, 2, 179, 0)
                        Else if row.Get("Status") = "DOWN" Then
                            pv(0).GetView(0).Color = xui.Color_ARGB(30, 255, 0, 0)
                        End If
                    Catch
                        Log(LastException)
                    End Try
                End If
            Next
        End If
    Next
    
End Sub
When i click next page (>) the empty rows are colored (see pics) and no 'higher-or-lower-than-last-row-values' are colored like page 1
Screenshot_1.png
Screenshot_2.png

Do i have something like B4XTable1.Refresh/Now? When i do it the whole Table hangs up.. the protocoll shows for every line happens something with following error:
(Exception) java.lang.Exception: java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Click to expand...
Therefore 'try' block.

Please help
 
Sort by date Sort by votes
bitben

bitben

Member
Licensed User
Longtime User
Yes, i want to compare the cell (RowId(0)) with cell before/above (RowId(1), is it higher (textcolor green) or lower (textcolor red) and is the K-Preis (BuyPrice) and VK-Preis (SellPrice) higher (backcolor green), neutral or lower (backcolor red) than the price before.

If i remove try block, the app crashes because of java error.
 
Last edited:
Upvote 0
bitben

bitben

Member
Licensed User
Longtime User
ok, here it is:
B4X: 
Logger connected with:  samsung SM-N935F
--------- beginning of main
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
(Exception) java.lang.Exception:  java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
java.lang.OutOfMemoryError: Failed to allocate a 805709884 byte allocation with 11484226 free bytes and 111MB until OOM
    at anywheresoftware.b4a.shell.Shell.createArray(Shell.java:573)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:380)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
java.lang.OutOfMemoryError: Failed to allocate a 134217740 byte allocation with 11489900 free bytes and 111MB until OOM
    at anywheresoftware.b4a.shell.ShellConnector.readObject(ShellConnector.java:281)
    at anywheresoftware.b4a.shell.Shell.setArrayElement(Shell.java:588)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:386)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
Error occurred on line: 491 (B4XTable)
java.lang.RuntimeException: Unexpected command: -46
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:426)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:80)
    at android.view.View.performClick(View.java:4780)
    at android.view.View$PerformClick.run(View.java:19866)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
Error occurred on line: 491 (B4XTable)
java.lang.RuntimeException: Unexpected command: 0
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:426)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:80)
    at android.view.View.performClick(View.java:4780)
    at android.view.View$PerformClick.run(View.java:19866)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
java.lang.OutOfMemoryError: Failed to allocate a 150994955 byte allocation with 11566968 free bytes and 111MB until OOM
    at anywheresoftware.b4a.shell.ShellConnector.readObject(ShellConnector.java:281)
    at anywheresoftware.b4a.shell.ShellConnector.readList(ShellConnector.java:222)
    at anywheresoftware.b4a.shell.Shell.fillHtSubs(Shell.java:595)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:369)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:80)
    at android.view.View.performClick(View.java:4780)
    at android.view.View$PerformClick.run(View.java:19866)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
java.lang.OutOfMemoryError: Failed to allocate a 134217740 byte allocation with 11474114 free bytes and 111MB until OOM
    at anywheresoftware.b4a.shell.ShellConnector.readObject(ShellConnector.java:281)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:710)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:80)
    at android.view.View.performClick(View.java:4780)
    at android.view.View$PerformClick.run(View.java:19866)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
** Service (starter) Destroy (ignored)**
*** Service (starter) Create ***
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
** Activity (data_history) Create, isFirst = true **
** Activity (data_history) Resume **
(RuntimeException) java.lang.RuntimeException: Class instance was not initialized (b4xtable)
Error occurred on line: 104 (Data_History)
java.lang.IndexOutOfBoundsException: Invalid index 16, size is 16
    at java.util.ArrayList.throwIndexOutOfBoundsException(ArrayList.java:255)
    at java.util.ArrayList.get(ArrayList.java:308)
    at anywheresoftware.b4a.objects.collections.List.Get(List.java:117)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:1082)
    at anywheresoftware.b4a.keywords.Common.CallSubNew(Common.java:1029)
    at bitben.TradingHelp.b4xtable$ResumableSub_ImplUpdateDataFromQuery.resume(b4xtable.java:3142)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:193)
    at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
    at anywheresoftware.b4a.keywords.Common$13.run(Common.java:1704)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:135)
    at android.app.ActivityThread.main(ActivityThread.java:5305)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)

Line 104 is in my code block line 20
B4X: 
pv(0) = p(0).CellsLayouts.Get(RowId(0))

With try block and return from 2 to 1 all is fine, it comes no error.

B4X: 
B4XTable1.VisibleRowIds.Size
shows on page 1 15 and on page 2 15, but in this case on page 2 should be 5.
 
Upvote 0
DonManfred

DonManfred

Expert
Licensed User
Longtime User
bitben said:
(Exception) java.lang.Exception: java.lang.IndexOutOfBoundsException: Invalid index 17, size is 16
Click to expand...

bitben said:
pv(0) = p(0).CellsLayouts.Get(RowId(0))
Click to expand...
so probably RowId(0) returns 17 where the CellsLayouts only contains 17 Items...

Maybe it should be RowId(0)-1?
 
Upvote 0
bitben

bitben

Member
Licensed User
Longtime User
DonManfred said:
so probably RowId(0) returns 17 where the CellsLayouts only contains 17 Items...

Maybe it should be RowId(0)-1?
Click to expand...
When i understood u right, i tried it, but don't worked, because for loop starts already with 0

Erel said:
First step is to remove the try / catch block.

What is the purpose of all this code? To highlight cells based on the value?
Click to expand...
Yes, i want to compare the cells in each row (i) with each cell in row (i-1) before.
Erel said:
There are several mistakes in your code and I also don't completely understand it.

1. If RowId = 0 then you need to clear previous markings.
2. There is no relation between the row id and CellLayouts. You should use CellLayouts.Get(i + 1) '+1 because of the header layout.
Click to expand...

I read an example of you and there you wrote

B4X: 
If RowId(0) > 0 Then
so i think i don't have to put i+1..? Because it starts at 1..?

Maybe we forget my code.
The general question is:
How can i set color text and -background for cells in actual row (i) depending on row (i-1) @ page 2+.
Click to expand...
For page 1 it worked, but page 2+ overtake the color settings from page 1, but i want new ones depending on new values in cells
 
Upvote 0
bitben

bitben

Member
Licensed User
Longtime User
i think i got it working, as far as good. Can i reset cell color to standard? Because gridlines disappear at xui color -1..

look here:

Screenshot_3.png

B4X: 
Sub B4XTable1_DataUpdated
   
    For i = 0 To B4XTable1.VisibleRowIds.Size-1
       
        'to get difference between row index and column index
        Dim rows_count As Int = B4XTable1.VisibleRowIds.Size
        rows_count = (B4XTable1.CurrentPage-1) * rows_count
       
        Dim RowId(2) As Long
        RowId(0) = B4XTable1.VisibleRowIds.Get(i)
        If i>0 Then RowId(1) = B4XTable1.VisibleRowIds.Get(i-1)
       
        If RowId(0) > 0 Then

            Dim xui As XUI
            Dim clr As Int = xui.Color_DarkGray
            Dim row As Map = B4XTable1.GetRow(RowId(0))

            For j = 2 To row.Size - 1

                If j <> 4 Then
                    Dim p(2) As B4XTableColumn
                    Dim pv(2) As B4XView
                   
                    'main row
                    p(0) = B4XTable1.Columns.Get(j)
                    pv(0) = p(0).CellsLayouts.Get(RowId(0)-rows_count)
                   
                    If i > 0 Then
                        'compare row
                        p(1) = B4XTable1.Columns.Get(j)
                        pv(1) = p(1).CellsLayouts.Get(RowId(1)-rows_count)
                       
                        'color depends on value difference
                        Dim tmp() As Double = Array As Double(pv(0).GetView(0).Text,pv(1).GetView(0).Text)
                        If tmp(0) > tmp(1) Then
                            clr = xui.Color_ARGB(255, 2, 179, 0)
                        Else If tmp(0) = tmp(1) Then
                            clr = xui.Color_DarkGray
                        Else If tmp(0) < tmp(1) Then
                            clr = xui.Color_Red
                        Else
                            clr = xui.Color_Magenta
                        End If
                    End If
                   
                    pv(0).GetView(0).TextColor = clr
                   
                    'color depends on column "Status"
                    If row.Get("Status") = "UP" Then
                        clr = xui.Color_ARGB(30, 0, 255, 0)
                    Else if row.Get("Status") = "DOWN" Then
                        clr = xui.Color_ARGB(30, 255, 0, 0)
                    Else
                        clr = -1
                    End If
                   
                    pv(0).GetView(0).Color = clr
                End If
            Next
        End If
    Next
    B4XTable1.GridColor = xui.Color_Black
End Sub

Maybe someone has a better or shorter version
 
Upvote 0
bitben

bitben

Member
Licensed User
Longtime User
Erel said:
See this short example: https://www.b4x.com/android/forum/t...ontent-and-then-disable-it.115988/post-724866
Click to expand...
Thanks, yes this is quite better to view. But i can't find any examples with more than 1 page. I would like to let away the sorting with pages, where do i have to set
B4X: 
B4XTable1.MaximumRowsPerPage
or similar to put all lines of data on first page and scroll down? Is this possible?
I think i will create a desktop application and send my data over tcp or udp to its datagridview.
 
Upvote 0
bitben

bitben

Member
Licensed User
Longtime User
Erel said:
You will not find any example of mine that only works with a single page. Try it.
Click to expand...
You are right, i was blind (like so often). Yours works great and in combination with mine all looks good.
I should get used to use this search function and not only google..

Thanks at you and all here
 
Upvote 0
You must log in or register to reply here.

Similar Threads

M
  • Question
Android Question B4XTable-Setup Table with Fewer Columns Using QueryBuilder Without Redefining Columns
Replies
4
Views
550
Erel
Erel
DALB
  • Question
Android Question B4XTable getting the values of a row : HOW TO ?
Replies
6
Views
2K
DALB
DALB
vecino
  • Solved
Android Question B4XTable, hide one or more columns
Replies
8
Views
2K
vecino
vecino
makis_best
  • Question
Android Question [SOLVED] B4XTable not show buttons in column
Replies
5
Views
821
makis_best
makis_best
M
  • Question
Android Question B4XTable Is Blank When Displaying Only One Column
Replies
1
Views
718
Erel
Erel
Top