Newbie- SQL ROWID problem

[enonod]

To keep control of records I am using...
lLastRec=gPage*gRows
...and then SQL statement...
SELECT * FROM Titles WHERE ROWID >0 AND ROWID <= lLastRec ORDER BY num

The SQL error 'No such column lLastRec'
suggests a variable cannot be used to compare ROWID. Having replaced it with a number and it works seems to confirm this.
This obviously presents a problem when trying to obtain sets of data to display one page at a time to avoid having scrollbars appear on the Table. It means a number must manually be provided per page.

I must have something wrong here.

 

[Erel]

There should be no problem using a variable, but you need to use the concatenation operator:
Cmd.CommandText = " SELECT * FROM Titles WHERE ROWID >0 AND ROWID <= " & ILastRec & " ORDER BY num"

 

[enonod]

Thank you Erel.