sqlite database

  1. A

    Android Question Strange problem

    I have 2 records in the database (see the attached image). I need to show the sum of Payment field and the max of PaidDate field. SELECT sum(PaidAmount) As PaidAmount, Max(PaidDate) As PaidDate FROM tblBilling where WeekEndDate='2024-11-16T00:00:00' The result is shown in the attached...
  2. Rasoull

    Android Question copy a table from one database to another

    Hello Is there any way to copy a table from one database to another in b4a?
  3. A

    Android Question Is it safe to do like this?

    Hi all and happy 2021. I'm run into the problem (yes, I know, my fault). The problem is that I saved date into my table like this 05/05/2020. For the whole year it was OK but this morning I realized that I did it wrong. When I run a query like this select * from mytable where jobdate between...
  4. S

    Android Question Get text from Xcustomlistview - SQLite Database

    I created a Xcustom list view as shown in this thread, https://www.b4x.com/android/forum/threads/b4x-xui-xcustomlistview-cross-platform-customlistview.84501/ to get data i used SQLite database. To load the layout I used the following code as shown in the above thread, Sub Process_Globals...
    • Salinda001
    • Thread
    • customlistview sqlite sqlite database text from customlistview xcustomlistview
    • Replies: 1
    • Forum: Android Questions
Top