another SQLite question: for...do

[gvanassche]

Dear all, this is what I do:


local q="SELECT * FROM table"
for row in db:nrows(q) do
sTexta=row.sTexta
db:exec("SELECT * FROM table WHERE id = '3')
sTextb=row.sTextb
end

The problem is:

sTexta I can retrieve
sTextb I cannot retrieve.


I get no error but sTextb is empty.

Is there a solution to this?

thanks

gert