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 $
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...
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")