Hello, I have just started playing with Sqlite. I was able to download the latest binary and start using it right away from a tclshell. It seems that the primary api is db eval command.
In the documentation and the FAQ's, I did not see this so I thought I would ask here for clarification: Is the concept of cursors supported? What I would like to do is, issue a select statement, see if it is OK or not, then do something else, and maybe retrieve the results of the statement. So, I need a way to refer to the result set after the statement has finished executing. For example, I would ask the user if they want to view the results if it is a select statement, and either display it page by page, or move on to something else. This is also useful from another point of view: even when the users do a plain select from a very large table, I wouldn't want the whole table loaded and returned to me right away. I hope this is clear, and thanks in advance for any suggestions. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
