Re: [sqlite] SQLite Documentation
On 04-12-10 17:30, Dagdamor wrote: > luuk34 писал(а) в своём письме Sat, 04 Dec 2010 > 20:24:45 +0600: >> On 04-12-10 14:15, Max Vlasov wrote: >>> Serge, I don't know what's so special about my chm viewer (bundled with >>> Windows 7), but I can only see the list of articles in the contents and >>> in >>> the search results on the left, the right pane always shows an error >>> about >>> canceling moving to a web-page. >>> >>> Max >> right click the file in explorer, and choose 'unblock' (on the >> general-tab) >> its there for 'safety'-purposes... ;-) >> >> you should, of course, only do this if you trust the docs... >> > Perhaps this is true, I'm still using win98, it's less restrictive :) > > The documents in the .chm are exact copies of the official documentation > files - I haven't touched them, didn't even add missing and > :P > It should be safe to open. > i should have added a link to microsoft, where they explain this: http://support.microsoft.com/kb/902225 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Documentation
luuk34 писал(а) в своём письме Sat, 04 Dec 2010 20:24:45 +0600: > > On 04-12-10 14:15, Max Vlasov wrote: >> >> Serge, I don't know what's so special about my chm viewer (bundled with >> Windows 7), but I can only see the list of articles in the contents and >> in >> the search results on the left, the right pane always shows an error >> about >> canceling moving to a web-page. >> >> Max > > right click the file in explorer, and choose 'unblock' (on the > general-tab) > its there for 'safety'-purposes... ;-) > > you should, of course, only do this if you trust the docs... > Perhaps this is true, I'm still using win98, it's less restrictive :) The documents in the .chm are exact copies of the official documentation files - I haven't touched them, didn't even add missing and :P It should be safe to open. Serge ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Documentation
On 04-12-10 14:15, Max Vlasov wrote: > On Sat, Dec 4, 2010 at 11:51 AM, Dagdamor wrote: > >> Hello. >> >> Would you like to have a downloadable version of the SQLite Documentation? >> I've created one in Windows HTML Help (.chm) format. It seems to be useful, >> single-file (no need to zip/unzip it), compact and easy to navigate/search. >> I've uploaded a copy to my server: >> > > Serge, I don't know what's so special about my chm viewer (bundled with > Windows 7), but I can only see the list of articles in the contents and in > the search results on the left, the right pane always shows an error about > canceling moving to a web-page. > > Max right click the file in explorer, and choose 'unblock' (on the general-tab) its there for 'safety'-purposes... ;-) you should, of course, only do this if you trust the docs... > ___ > 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 Documentation
On Sat, Dec 4, 2010 at 11:51 AM, Dagdamor wrote: > Hello. > > Would you like to have a downloadable version of the SQLite Documentation? > I've created one in Windows HTML Help (.chm) format. It seems to be useful, > single-file (no need to zip/unzip it), compact and easy to navigate/search. > I've uploaded a copy to my server: > Serge, I don't know what's so special about my chm viewer (bundled with Windows 7), but I can only see the list of articles in the contents and in the search results on the left, the right pane always shows an error about canceling moving to a web-page. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Recursive calls to sqlite3_exec
Can sqlite3_exec and/or sqlite3_prepare be re-entered? I notice that data dictionary updates are done directly with the Vdbe engine rather then the public API - will I have to resort to that? I tried using sqlite3NestedParse, but changes to the db don't seem to be reflected immediately. I want to implement a custom function that may conditionally run DML/DDL. Thanks, -Chris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 4 Dec 2010, at 10:42, Dan Kennedy wrote: > On 12/04/2010 12:54 AM, Philip Graham Willoughby wrote: >> On 2 Dec 2010, at 20:43, Sylvain Pointeau wrote: >> >>> Hi, >>> >>> I am on macosx sqlite 3.7.3 >>> >>> $ /usr/local/bin/sqlite3 test.db3 >>> SQLite version 3.7.3 >>> Enter ".help" for instructions >>> Enter SQL statements terminated with a ";" >>> sqlite> .read ./testSchema.sql >>> sqlite> .read ./TestValues.sql >>> sqlite> .read ./TestQuery.sql >>> Otterbourne Golf Course|Jane Doe|Assumed Name >>> >>> it works for me. >> >> By default, assertions are not built - did you build with SQLITE_DEBUG? >> Assuming you did, what were your other build flags and which compiler did >> you use? > > Thanks for following up on this - your post on the 26th of last > month slipped through a crack... > > Turns out the bug is in the assert(), not the production code, so > there is no problem in non-SQLITE_DEBUG builds. It's now fixed for > 3.7.4. Brilliant news, thank you for looking into it. Best Regards, Phil Willoughby -- Managing Director, StrawberryCat Limited StrawberryCat Limited is registered in England and Wales with Company No. 7234809. The registered office address of StrawberryCat Limited is: 107 Morgan Le Fay Drive Eastleigh SO53 4JH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 12/04/2010 12:54 AM, Philip Graham Willoughby wrote: > On 2 Dec 2010, at 20:43, Sylvain Pointeau wrote: > >> Hi, >> >> I am on macosx sqlite 3.7.3 >> >> $ /usr/local/bin/sqlite3 test.db3 >> SQLite version 3.7.3 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> .read ./testSchema.sql >> sqlite> .read ./TestValues.sql >> sqlite> .read ./TestQuery.sql >> Otterbourne Golf Course|Jane Doe|Assumed Name >> >> it works for me. > > By default, assertions are not built - did you build with SQLITE_DEBUG? > Assuming you did, what were your other build flags and which compiler did you > use? Thanks for following up on this - your post on the 26th of last month slipped through a crack... Turns out the bug is in the assert(), not the production code, so there is no problem in non-SQLITE_DEBUG builds. It's now fixed for 3.7.4. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
sorry yes I didn't compile with SQLITE_DEBUG I just did it, and I have the same error: $ /usr/local/bin/sqlite3 tst.db3 SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Assertion failed: (memIsValid(&u.bq.r.aMem[i])), function sqlite3VdbeExec, file sqlite3.c, line 64507. Abort trap On Sat, Dec 4, 2010 at 11:20 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > I used: > CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' > ./configure --disable-dependency-tracking > > my compiler is: > $ gcc --version > i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664) > Copyright (C) 2007 Free Software Foundation, Inc. > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
I used: CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure --disable-dependency-tracking my compiler is: $ gcc --version i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664) Copyright (C) 2007 Free Software Foundation, Inc. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Documentation
Hello. Would you like to have a downloadable version of the SQLite Documentation? I've created one in Windows HTML Help (.chm) format. It seems to be useful, single-file (no need to zip/unzip it), compact and easy to navigate/search. I've uploaded a copy to my server: http://www.phpc.ru/files/sqlite/sqlite_docs_3_7_3.chm This one is based on the "sqlite_docs_3_7_3.zip" file. Feel free to use it if you like. Any comments/suggestions are welcome. And thank you for the SQLite :) Regards, Serge Igitov (Dagdamor) www.phpc.ru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users