Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Stefano Ravagni wrote: > > The application run well, so good! The HasRows properties return TRUE as > far as i close datareader explicity > Excellent. > > I hope after new compilation of library, i'll just have to reference the > system.Data.SQLite.dll and not all x86 contents...is right ? > If you use one of the mixed-mode assemblies, yes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Hello Joe, yesterday i tryed the StickyHasRows properties passed on connection string... As in your suggestion, i add reference to new 1.0.92 version and i also copy all files in x86 directory in my BIN directory. The application run well, so good! The HasRows properties return TRUE as far as i close datareader explicity I'm satisfied and now i could use SQLite in my application... I hope after new compilation of library, i'll just have to reference the system.Data.SQLite.dll and not all x86 contents...is right ? Let me know if you receive my feedback and have a good day! 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. properties in next compiled versione ? If yes, when you think is ready for download (about) ? The addition of the StickyHasRows feature is pending; however, we were hoping to get your feedback prior to including it in the release to make sure that it works for the specific scenarios that you mentioned previously. The next version is scheduled to be released sometime this week, barring any more late-breaking changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Hello Joe, i just tryed the StickyHasRows properties passed on connection string... As in your suggestion, i add reference to new 1.0.92 version and i also copy all files in x86 directory in my BIN directory. The application run well, so good! The HasRows properties return TRUE as far as i close datareader explicity I'm satisfied and now i could use SQLite in my application... I hope after new compilation of library, i'll just have to reference the system.Data.SQLite.dll and not all x86 contents...is right ? Let me know if you receive my feedback and have a good day! 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. properties in next compiled versione ? If yes, when you think is ready for download (about) ? The addition of the StickyHasRows feature is pending; however, we were hoping to get your feedback prior to including it in the release to make sure that it works for the specific scenarios that you mentioned previously. The next version is scheduled to be released sometime this week, barring any more late-breaking changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
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... You would need to recompile your application against the new System.Data.SQLite assembly, not System.Data.SQLite itself. properties in next compiled versione ? If yes, when you think is ready for download (about) ? The addition of the StickyHasRows feature is pending; however, we were hoping to get your feedback prior to including it in the release to make sure that it works for the specific scenarios that you mentioned previously. The next version is scheduled to be released sometime this week, barring any more late-breaking changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
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 in next compiled versione ? If yes, when you think is ready > for download (about) ? > The addition of the StickyHasRows feature is pending; however, we were hoping to get your feedback prior to including it in the release to make sure that it works for the specific scenarios that you mentioned previously. The next version is scheduled to be released sometime this week, barring any more late-breaking changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
A... ok...is this the problem... I cannot recompile because i run under Windows XP and without Visual C, i use Visual Basic... I use SQLite as a referenced library, so i have to wait for a new compiled version... I will found the StickyHasRows properties in next compiled versione ? 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." Can you make sure that all the binaries included in that ZIP file end up in the application binary directory? This is especially important for the "x86" and "x64" directories within the archive. They should be extracted verbatim into the application binary directory. Also, you might need to recompile your application to refer to the new version of System.Data.SQLite, which is 1.0.92.0. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
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." > Can you make sure that all the binaries included in that ZIP file end up in the application binary directory? This is especially important for the "x86" and "x64" directories within the archive. They should be extracted verbatim into the application binary directory. Also, you might need to recompile your application to refer to the new version of System.Data.SQLite, which is 1.0.92.0. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
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."
The error happen in this line of my code:
MyDBFactory = DbProviderFactories.GetFactory("System.Data.SQlite")
I forgot something ??
I can 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 to use in same
waybut many others developer, who use HasRows for check if
datareader has or had records will be gratified to this new
capacity...don't think ??
I have figured out a backwards compatible way to enable this behavioral
change.
It involves modifying the connection string used when creating the
associated connection by modifying [or adding] the Flags connection
string property to include the StickyHasRows value, e.g.:
"Data Source=:memory:;Flags=StickyHasRows;"
Currently, these changes can be seen on the stickyHasRows branch, here:
https://system.data.sqlite.org/index.html/timeline?r=stickyHasRows
Would this satify your requirements?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Hello and thanks for reply ... You want say i have just to add " Flags=StickyHasRows;" to normal string connection and i could use hasrows in the way i say? If yes, i like this way! When could i try the compiled version for make somes tests? 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 to use in same >> waybut many others developer, who use HasRows for check if >> datareader has or had records will be gratified to this new >> capacity...don't think ?? >> > >I have figured out a backwards compatible way to enable this behavioral >change. > >It involves modifying the connection string used when creating the >associated connection by modifying [or adding] the Flags connection >string property to include the StickyHasRows value, e.g.: > > "Data Source=:memory:;Flags=StickyHasRows;" > >Currently, these changes can be seen on the stickyHasRows branch, here: > > https://system.data.sqlite.org/index.html/timeline?r=stickyHasRows > >Would this satify your requirements? > >-- >Joe Mistachkin > >___ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Stefano Ravagni wrote: > > In addiction..what change in backward compatybilities ? I think nothing... > Who use datareader with "while .read do " continue to use in same > waybut many others developer, who use HasRows for check if > datareader has or had records will be gratified to this new > capacity...don't think ?? > I have figured out a backwards compatible way to enable this behavioral change. It involves modifying the connection string used when creating the associated connection by modifying [or adding] the Flags connection string property to include the StickyHasRows value, e.g.: "Data Source=:memory:;Flags=StickyHasRows;" Currently, these changes can be seen on the stickyHasRows branch, here: https://system.data.sqlite.org/index.html/timeline?r=stickyHasRows Would this satify your requirements? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
I'm sorry, maybe i've not your knowledge
...but could you tell me why in your mind database library for .net as
MySql connector, ODBC for Postgres, all Access drivers, NPGSQL and many
others permit read hasrows properties also after data association as i
say and SQlite not ?
In addiction..what change in backward compatybilities ? I think nothing...
Who use datareader with "while .read do " continue to use in same
waybut many others developer, who use HasRows for check if
datareader has or had records will be gratified to this new
capacity...don't think ??
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
and I assume that they know how to properly implement their own database
access interfaces.
Tell me please because i'm not sure to had understand in next
version could i check dati.hasrows and have to return TRUE value also
after data association or have i to combine the use with StepCount
properties ?
No, for several reasons:
1. It would not be a backward compatible change.
2. It would not be compatible with several other ADO.NET providers
(e.g. SQL Server).
3. The IDataReader.Read() method return value can be used instead (see
example below) and has the additional benefit of being more widely
available since it is required on any class that implements the
IDataReader interface, not just those derived from the DbDataReader
abstract class.
bool hasRows = false;
do {
if (dataReader.Read()) {
hasRows = true;
// process this row...
} else {
// no more rows.
break;
}
} while (true);
if (hasRows) {
// more code here...
}
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
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
and I assume that they know how to properly implement their own database
access interfaces.
>
> Tell me please because i'm not sure to had understand in next
> version could i check dati.hasrows and have to return TRUE value also
> after data association or have i to combine the use with StepCount
> properties ?
>
No, for several reasons:
1. It would not be a backward compatible change.
2. It would not be compatible with several other ADO.NET providers
(e.g. SQL Server).
3. The IDataReader.Read() method return value can be used instead (see
example below) and has the additional benefit of being more widely
available since it is required on any class that implements the
IDataReader interface, not just those derived from the DbDataReader
abstract class.
bool hasRows = false;
do {
if (dataReader.Read()) {
hasRows = true;
// process this row...
} else {
// no more rows.
break;
}
} while (true);
if (hasRows) {
// more code here...
}
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Stefano Ravagni wrote: > > Yes, i think tue value have to remain constant as far as i explicit close datareader. > This have an important effect; possibility to valle a datareader in a specific routine > and obtain hasrows value out of this routine. > The MSDN docs are unclear on this point; however, other ADO.NET providers seem to follow the System.Data.SQLite behavior you are seeing. Meanwhile, I've added a new SQLiteDataReader.StepCount property on trunk that will return the number of rows seen so far. Checking if this value is greater than zero may work for your use case, when combined with the HasRows property, e.g.: If Dati.HasRows = True Or Dati.StepCount > 0 Then ... code here ... End If This new property will be present in the 1.0.92.0 release, due out next week. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
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, Joe Mistachkin ha scritto: > > > If you have any issues with the current code, please report them via this > mailing > list (and/or by creating a ticket on "https://system.data.sqlite.org/";) > prior to > this coming Friday, March 14th. > > Thanks. > > -- > Joe Mistachkin > > ___ > sqlite-dev mailing list > sqlit...@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Stefano Ravagni wrote: > > i use a code like this: > > If Dati.HasRows = True Then > sorgente.DataSource = Dati > . > . > end if > > If Dati.HasRows = True then > . make something others > end if > My reading of MSDN indicates that the HasRows property value can change after calls to the Read method (which is used prior to actually reading each result row). In your sample code, using the SQLiteDataReader as a data source will almost certainly change the HasRows property. I've added a test that demonstrates how this works, here: https://system.data.sqlite.org/index.html/ci/7fb5c1cd3e?sbs=0&w Based on your previous statements, it sounds like you may have expected the return value of the HasRows property to remain constant (i.e. even after reading some or all of the available rows)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...
Stefano Ravagni wrote: > > i encounter problem with datareader hasrows properties... > Do you have some example code that demonstrates the issue? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
