This is a small class to easily build SQL queries
declare an instance of the class clBuildSQL and initialize it
Private fBuildSQL As clBuildSQL
Just pass as first parameter the table name and as second parameter a map with pairs keys/values...
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")