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 ??
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.