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