[sqlite] Datareader HasRows became empty after binding source

2014-03-13 Thread Stefano Ravagni
Hello, i'm a .NET developer and i'm trying to use Sqlite as connector. I could see in an instruction as If Dati.HasRows = True Then sorgente.DataSource = Dati end if where DATI is a datareader object and SORGENTE is a BINDINGSOURCE object, after association with from datareader

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-13 Thread Stefano Ravagni
i encounter problem with datareader hasrows properties... After data association the property became FALSE also if data is present Is not good thing for who use datareader.hasrows for check data presence... Is possible to fix this problem ? Il giorno martedì 11 marzo 2014 02:22:31 UTC+1,

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-15 Thread Stefano Ravagni
Il 14/03/2014 2.01, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Only SQL Server don't follow this line for what i know, and because of that i abandon it in favor of SQlite (as file system database) and PostgreSQL. Well, the SQL Server provider is included with the .NET Framework itself an

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-17 Thread Stefano Ravagni
see the beta library is mre small as previous stable version ...is normal ? Il 17/03/2014 5.41, Joe Mistachkin ha scritto: Stefano Ravagni wrote: In addiction..what change in backward compatybilities ? I think nothing... Who use datareader with "while .read do " continue

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-17 Thread Stefano Ravagni
? If yes, when you think is ready for download (about) ? Thanks for your interest ! Il 17/03/2014 21.01, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i tryed the beta library you propose to me... but i obtain this error: "Exception has been thrown by the target of an invocation.&q

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-17 Thread Stefano Ravagni
Ok, tomorrow i'll try again to use followind your instructions and i'll feedback answer this emaili hope to be able... Il 17/03/2014 22.27, Joe Mistachkin ha scritto: Stefano Ravagni wrote: I cannot recompile because i run under Windows XP and without Visual C, i use Visual Basic

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-18 Thread Stefano Ravagni
17/03/2014 22.27, Joe Mistachkin ha scritto: Stefano Ravagni wrote: I cannot recompile because i run under Windows XP and without Visual C, i use Visual Basic... You would need to recompile your application against the new System.Data.SQLite assembly, not System.Data.SQLite itself. properties

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-19 Thread Stefano Ravagni
! Il 17/03/2014 22.27, Joe Mistachkin ha scritto: Stefano Ravagni wrote: I cannot recompile because i run under Windows XP and without Visual C, i use Visual Basic... You would need to recompile your application against the new System.Data.SQLite assembly, not System.Data.SQLite itself

[sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Stefano Ravagni
Hello, i'm new in SQLite develop... i'n a gridview (.NET) i visualize the data type in -MM-DD format Using others database i ever see data in format which follow culture setting (italian in this case)... but not in SQLite.. How could i solve ?

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Stefano Ravagni
14:39:39 -0700 (PDT), Stefano Ravagni <stefanorava...@gmail.com> wrote: Hello, i'm new in SQLite develop... i'n a gridview (.NET) i visualize the data type in -MM-DD format Using others database i ever see data in format which follow culture setting (italian in thi

[sqlite] cannot set connection while a datareader is active

2014-04-09 Thread Stefano Ravagni
Hello, i have a problem with SQlite and i would ask if someone had solved it. I obtain this error: "cannot set connection while a datareader is active" but nothing apparent cause this bahavior Is a knowed error message tha i could fix ? If i drive slow execution of code debugging it

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Stefano Ravagni
Il 14/04/2014 0.22, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, here my code for CloseDati to help you to reproduce the error that i don't understand... ++ Public Sub CloseDati() 'chiude i dati del datareader associati all'oggetto DATI cui

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Stefano Ravagni
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

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Stefano Ravagni
Il 14/04/2014 0.22, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, here my code for CloseDati to help you to reproduce the error that i don't understand... ++ Public Sub CloseDati() 'chiude i dati del datareader associati all'oggetto DATI cui

Re: [sqlite] cannot set connection while a datareader is active

2014-04-15 Thread Stefano Ravagni
; Joe Mistachkin <sql...@mistachkin.com> ha scritto: > > > > Stefano Ravagni wrote: > > > > So what have i do? Need to see others setting or state? > > > > It would be useful to try and examine the internal state of the > SQLiteCommand and see if the _activeRe

Re: [sqlite] cannot set connection while a datareader is active

2014-04-16 Thread Stefano Ravagni
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

Re: [sqlite] cannot set connection while a datareader is active

2014-04-16 Thread Stefano Ravagni
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

[sqlite] Why my question are not visibile in this group ?

2014-04-17 Thread Stefano Ravagni
Why my question are not visibile in this group ? I send question but never see published... i have many difficult to understand the way of support for Sqlite ... ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] cannot set connection while a datareader is active

2014-04-17 Thread Stefano Ravagni
Il 16/04/2014 22.33, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i cannot find the way for follow the command object properties you saycould you tell me what and how to observe exactly please ? You might need to add the System.Data.SQLite project(s) to the solution in order

Re: [sqlite] cannot set connection while a datareader is active

2014-04-19 Thread Stefano Ravagni
Il 16/04/2014 22.33, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i cannot find the way for follow the command object properties you saycould you tell me what and how to observe exactly please ? You might need to add the System.Data.SQLite project(s) to the solution in order

Re: [sqlite] cannot set connection while a datareader is active

2014-04-19 Thread Stefano Ravagni
Il 19/04/2014 20.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe have you somes help advice for my case ? I don't receive your answer from 3 days... I'm still unable to reproduce the behavior you describe here locally. Are you able to post all the code that interacts

Re: [sqlite] cannot set connection while a datareader is active

2014-04-20 Thread Stefano Ravagni
Il 20/04/2014 6.00, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Is a big project wich re-call many function and interacts many times with sqlite provider... i could try to isolate a piece of code but isolating the code i don't know if the error will be reproduced...but i will try

Re: [sqlite] cannot set connection while a datareader is active

2014-04-21 Thread Stefano Ravagni
h have not to say with the problem i ask solutioni'm sorry for that, i tryed to make a slim project for reproduce error only... A put a RAR archive with the slim project at this link: https://www.dropbox.com/s/bugysawir52ivna/TestSQLite.rar 2014-04-20 6:00 GMT+02:00 Joe Mistachkin <sql...@

Re: [sqlite] cannot set connection while a datareader is active

2014-04-22 Thread Stefano Ravagni
Il 21/04/2014 21.54, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Thanks for answer Joe, but as just sayed i have only one datareader, That is not possible. There must be at least two different data reader instances because the references in the watch window did not match. Every time

Re: [sqlite] cannot set connection while a datareader is active

2014-04-22 Thread Stefano Ravagni
? If exist it have to be in the sent code, but i don't see nothing.. you could? Joe Mistachkin <sql...@mistachkin.com> ha scritto: Stefano Ravagni wrote: Thanks for answer Joe, but as just sayed i have only one datareader, That is not possible. There must be at least two differen