Dim s As String = $"
SELECT * FROM tbl WHERE userid = ?
UNION
SELECT * FROM tbl OFFSET LIMIT ?,?"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid, 0,10))
Dim s As String = $"
SELECT * FROM hesabdari WHERE userid = ?
UNION
SELECT * FROM hesabdari OFFSET LIMIT ?,?"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid, counter,19))
why two sql then for this if it can be done with ONE simple SQL like @jmon suggested in #4i mean i want select 10records where userid=x from tbl
use LIMITbut i want select rows 0-10 or 10-15 or x-y with offset where uid=x
Dim s As String = $"
SELECT * FROM tbl WHERE uid = ? LIMIT ?,?;"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid,9,5))
use LIMIT
LIMIT 0,10 (0 to 9)
LIMIT 9,5 (10 to 15)
something like
I strongly suggest to learn the SQL Language basics.B4X:Dim s As String = $" SELECT * FROM tbl WHERE uid = ? LIMIT ?,?;"$ Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid,9,5))