> Hi there, > > Is it possible to get a list of say, the last 10 executed SQL commands? This > would be very usefull for debugging purposes for example. The FAQ doesn't > answer the question.
If you are using the command line utility in a DOS shell in Windows, the up arrow key will show you every command you've executed. I'm sure there's a limit, but I don't know what it would be. If you are talking about SQLite in general, I believe the answer is "only if you save 'the last 10 executed SQL commands' you've performed. It shouldn't be difficult to set up a table to hold those, and a wrapper function that updates that table every time a query is run.