[sqlite] How do you access a specific row of a resultset?

Hi, I want to know how to go about getting a specific row from a resultset (or if there is a different way to do it Im all for that too) My code goes something like this, stat being a statement variable already initialised previously. I thought perhaps absolute sounds like it might give the

Re: [sqlite] How do you access a specific row of a resultset?

Well, a new thought just came to me, if I use the same sql statement will the resultset be in the same order each time because if that is the case I imagine I could use a for statement and an index to move through it the way I want to with next inside of that as many times as it takes to get to