query

  1. 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...
  2. 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)...
  3. 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 ??
  4. 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?
  5. 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...
  6. 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