it modify the test.cs file (uploaded to feature request section) and the error is that the connection state keep being "executing" so that I cannot perform another query.
reader.Close() must be called to release the connection and be able to use it again in the next ExecuteReader call.
I got it. each reader.close should be executed before cmd.executexxx
I have the same problem, but can't close the reader/command, eg:
cmdA = "select * from table1"
dsA = cmdA.executereader()
do while dsA.read
' This next line causes an exception
Dim cmdB As SQLiteCommand = _db.CreateCommand
cmdB = "select * from unrelated_other_table"
dsB = cmd.executereader()
It apears that you can't have multiple command objects. Is this correct??
Are you sure that the creation of the command and not ExecuteReader causes an exception? You can create several commands from the same connection, but you can not have several opened DataReaders serving by the same connection. You must create a second connection, create the command from it and execute reader then.
OK. The version 0.14 supports several opened DataReaders from one SQLiteConnection. See the function TwoSimultaneousReaders in UnitTests/DataReaderTests.cs for example.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.