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))
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))
first shuold i select all row where uid=x
then i want to select 0-10 rows or x-y row from rows that fetched from first step
maybe first step return 50 rows i want select 0-10 records or 10-20 records (start pos- end pos)
ok ??