I’ve been creating and storing information into an SQLITE database using tcl with no problem. Now I’m trying to extract data and I’m trying to figure out how to select a row and process each row before selecting the next row. Unlike Oracle and other DBMS where you can build a cursor and select each row and process it, there is no cursor functionality in SQLITE. When I use the select statement in SQLITE I get all rows I define in my select returned to me. I do see an array “parray” parameter in the sqlite documentation. Do I select into an array then loop through the array using tcl statements. I’m still researching for a select and process one row at a time solution. Does anybody out there have any ideas or a tcl script that selects rows and processes each row as it is read form the db.
.
