Il 14/04/2014 21.12, Joe Mistachkin ha scritto:
Stefano Ravagni wrote:
Hello Joe, tryed to change the code in the IF expression but nothing
change....
I would ask if you seen the screenshot i attached somes days ago because
it show what happen....
From debugger Datareader result CLOSED and HasRows properties result NO
ROWS, but i obtain the error wich say datareader is open !
The error happen at line were i set command connection properties as in
the code above...
Try
Call CloseDati() ' which call Dati.Close()
objCmd.Connection = Connetti *** HERE HAPPEN THE ERROR
***
objCmd.CommandText = strSQLvar
Dati = objCmd.ExecuteReader()
...........
The only thing that I can think of is that somehow the data reader being
closed
is not the same one associated with the command you are attempting to set
the
connection of.
Are you 100% sure that the "Dati" data reader is associated with the
"objCmd"
command?
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am thinking about one thing.... System.Data.Sqlite.Dll have abilities
to return Multiple result sets or not ? could be this the motivation
because SQlite is the only database who get me this error ? ... or this
abilities is already supported ?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
