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)
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 ??
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?
I have same problem again.
my customlistview taking more than 4 min for nearly 1200 records of sqlite
my code is :
cursor = Starter.year.ExecQuery("select * from GL where FBOOK='G001' order by FDESC")