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

Stefano Ravagni wrote: > > If yes, i like this way! When could i try the compiled version for make somes tests? > Here is a temporary set of debug binaries for the .NET Framework 4.0 (or higher): https://system.data.sqlite.org/temporary/System.Data.SQLite-StickyHasRows-59 fcdb.zip -- Joe M

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 wro

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

Re: [sqlite] System.Data.SQLite Deployment Mystery

dpybus wrote: > > I have an identical problem. I cannot deploy an app which uses either Net 4.5 > or 4.5.1 with the appropriate sqlite dll. It can be fixed by installing the > sqlite package on the target computer. > Generally, there are three types of issues with System.Data.SQLite deployment:

Re: [sqlite] Execute Error Notification

On 16 Mar 2014, at 7:16pm, RSmith wrote: > My question is though, is there a way to learn somehow whether a rollback or > constraint violation happened during the whole execute process which caused a > rollback? > > Kind of like saying: "Yes I know the script executed fully, but was there a

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hi again, I confess I have difficulties to diggest your code. >From your experience to reach this success, would you have some hints for SQLite team that would allow the code to become more easy to read and stay performant ? Example : - a non-performant implementation of 'this' required 'that' c

[sqlite] Execute Error Notification

I use quite a few script-type sql lists to achieve some functions in some systems, by which I basically mean I make up a list of SQL statements and then just send them to the very convenient sqlite3_exec() function when I'm pretty sure I cannot do it any faster by individual steps or speed is n

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Op 16 mrt 2014, om 16:45 heeft big stone het volgende geschreven: Hi Edzard, I just reproduced your test. Indeed : - you probably blew-up everything running SQL sudoku on this planet : . 'hardest1' in under 2 seconds on my machine, . 'eastermonster1' in 43ms. - with Norvig's method and av

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hi Edzard, I just reproduced your test. Indeed : - you probably blew-up everything running SQL sudoku on this planet : . 'hardest1' in under 2 seconds on my machine, . 'eastermonster1' in 43ms. - with Norvig's method and available SQLite syntax. Each of these feats is jaw-dropping. Regar

Re: [sqlite] System.Data.SQLite Deployment Mystery

I have an identical problem. I cannot deploy an app which uses either Net 4.5 or 4.5.1 with the appropriate sqlite dll. It can be fixed by installing the sqlite package on the target computer. -- View this message in context: http://sqlite.1065341.n5.nabble.com/System-Data-SQLite-Deployment-Mys

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hello The SQLite version is 3.8.4 by now and this is stil about the sudoku solving. I studied Norvigs algorithm (Python) http://norvig.com/sudoku.html . It is possible to achieve this method in SQL. A very important difference between Norvigs programme and the SQLite example is however th