Android Question [SOLVED] B4XTable ExecNonQuery2 Select

makis_best said:

That means we can execute select, insert and updates,... correct?

Click to expand...

Mahares said:

Yes. See this thread for a code snippet example:
https://www.b4x.com/android/forum/threads/b4xtable-add-lines-rows.104549/#post-655142

Click to expand...

B4XTable1.sql1.ExecQuery("SELECT * FROM table1")

Erel said:

What do you want to do with the result of the select query? If you want to show it in the table then call Table.CreateDataView instead.

Click to expand...

makis_best said:

I want to do calculations based of user input.

Click to expand...

    Dim rs As ResultSet = B4XTable1.sql1.ExecQuery("Select SUM(c7) From Data")
    If rs.NextRow Then
        If rs.GetString(rs.GetColumnName(0)) <> Null Then
            totalOrders = rs.GetString(rs.GetColumnName(0))
        Else
            Return
        End If
    
        Dim rs As ResultSet = B4XTable1.sql1.ExecQuery("Select SUM(c8) From Data")
        If rs.NextRow Then
            totalTips = rs.GetString(rs.GetColumnName(0))
        End If
    End If

   lblTips.Text = "Tips: $" & NumberFormat(totalTips,1,2)
   lblOrders.Text = "Orders: $" & NumberFormat(totalOrders,1,2)

jimmyF said:

This is what I do in the B4XTable1_DataUpdated sub

Click to expand...

Dim rs As ResultSet = B4XTable1.sql1.ExecQuery("Select SUM(c7) as SC7, SUM(c8) as SC8 From Data")
   If rs.NextRow Then
            lblTips.Text = "Tips: $" & NumberFormat(rs.GetDouble("SC7"),1,2)
            lblOrders.Text = "Tips: $" & NumberFormat(rs.GetDouble("SC8"),1,2)
    End If

Mahares said:

Could you have combined both transactions in one like this:

Click to expand...