query

  1. Alexander Stolte

    Android Example [B4X] Supabase - Database Joins

    https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ In the following example I make a join into the "public.users" table and need the column "username" from it. Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData...
  2. behnam_tr

    B4J Question [Solved] SqlLite , How Select data per month ??

    hello my friends I have the following database table and I want to extract the Monthly profit (from the profit column) information with the optimal code. Does anyone have a solution ?? In fact, how many profit did we have per month? like this : Month 1 >> 250,000 $ Month 2 >> 300,000 $ ...
  3. rleiman

    Android Question [Solved] - Querying the TalkBack status

    Greeting everyone, I found some code in the forum that should be telling me if TalkBack is turned on by the user. The Log statement returns True with TalkBack turned off as well as on. The code is from 2012 so maybe it's too much outdated? If that's the case, is there any updated code that will...
  4. S

    B4J Library Build parametized SQL queries for Insert,Update and Delete

    This is a small class to easily build SQL queries declare an instance of the class clBuildSQL and initialize it Private fBuildSQL As clBuildSQL .... fBuildSQL.initialize Insert record Just pass as first parameter the table name and as second parameter a map with pairs keys/values...
  5. K

    Android Question Sqlite android.database.CursorWindowAllocationException

    I'm getting this error again. Error occurred on line: 479 (MysqlEntrySync) android.database.CursorWindowAllocationException: Cursor window allocation of 2097152 bytes failed. # Open Cursors=920 (# cursors opened by this proc=920) at android.database.CursorWindow.<init>(CursorWindow.java:136)...
  6. behnam_tr

    B4J Question how combine two sql query

    hi i want to combine two sql query Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl WHERE userid = ? ", Array As Int(uid)) Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl OFFSET LIMIT ?,?",Array As String(0,10)) how do i this ??
  7. K

    Android Question TransactionTooLargeException

    https://www.b4x.com/android/forum/threads/error-with-customlistview.97829/ As per discussion in this forum I got that TransactionTooLargeException error is in sql query I change query and add limit in that, its working fine now. But I have to add all records in clv, What should I do?
  8. K

    Android Question CustomListView running too slow

    I have same problem again. my customlistview taking more than 4 min for nearly 1200 records of sqlite 7.12.00 7.16.00 my code is : cursor = Starter.year.ExecQuery("select * from GL where FBOOK='G001' order by FDESC") Dim...
  9. K

    Android Question sqlite query with function

    I have a query "select *,closing as closing(parameter1,parameter2) from temp" how to pass this query i have to used function how to do that?
Top