Re: [sqlite] Multiple SQLiteDataReader objects against a single connection

2014-07-01 Thread Joseph L. Casale
> By doing exactly what you have described. > > What is the problem? Hey Clemens, Sorry I should have updated the thread, I was receiving an "There is already an open DataReader associated with this Command which must be closed first." exception which was simply from a lack of paying attention.

Re: [sqlite] Multiple SQLiteDataReader objects against a single connection

2014-07-01 Thread Clemens Ladisch
Joseph L. Casale wrote: > How does one accomplish this in the case where I iterate over a long result > set > with the first reader open, then open a new reader against a prepared > statement > and pass in a value derived from the first reader. By doing exactly what you have described. What is

[sqlite] Multiple SQLiteDataReader objects against a single connection

2014-06-30 Thread Joseph L. Casale
Hey guys, How does one accomplish this in the case where I iterate over a long result set with the first reader open, then open a new reader against a prepared statement and pass in a value derived from the first reader. Thanks, jlc ___ sqlite-users