Re: [sqlite] Sqlite support for UCLINUX

2013-08-15 Thread Dan Kennedy
On 08/15/2013 11:42 AM, Ajazur Rahaman wrote: Dear sir, Do we have sqlite support for UCLINUX Kernel Version 2.6.38 ? If it is ,from which version it is supported. We are trying to compile sqlite-3.6.12 autoconf code to get executables so as to run it on our Board which has no support

[sqlite] Sqlite Support for UCLINUX

2013-08-15 Thread Aijas Mohammed
Dear sir, Do we have sqlite support for UCLINUX Kernel Version 2.6.38 ? If it is ,from which version it is supported. We are trying to compile sqlite-3.6.12 autoconf code to get executables so as to run it on our Board which has no support for MMU(Memory Management Unit). Below is the cross

Re: [sqlite] name resolutionn in GROUP BY

2013-08-15 Thread Marc L. Allen
Good point. Ok.. I'm convinced. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James K. Lowden Sent: Thursday, August 15, 2013 12:27 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] name resolutionn in GROUP BY On Wed,

[sqlite] warning: ‘_popen’ redeclared without dllimport attribute

2013-08-15 Thread Jan Nijtmans
When compiling latest SQLite (actually: fossil) with mingw, I get the warnings below. Here is my suggested fix (attached). Regards, Jan Nijtmans == src/shell.c:68:15: warning: ‘_popen’ redeclared without dllimport attribute: previous dllimport ignored

Re: [sqlite] warning: ‘_popen’ redeclared without dllimport attribute

2013-08-15 Thread Richard Hipp
Attachments are omitted on this mailing list. -- D. Richard Hipp Sent from phone - Excuse brevity On Aug 15, 2013 9:26 AM, Jan Nijtmans jan.nijtm...@gmail.com wrote: When compiling latest SQLite (actually: fossil) with mingw, I get the warnings below. Here is my suggested fix (attached).

Re: [sqlite] warning: ‘_popen’ redeclared without dllimport attribute

2013-08-15 Thread Jan Nijtmans
2013/8/15 Richard Hipp d...@sqlite.org: Attachments are omitted on this mailing list. Sorry, I didn't know that. Here is the same patch inline. (Just move the #endif after the pclose definition) Thanks! Regards, Jan nijtmans --- src/shell.c +++ src/shell.c @@ -69,16 +69,16 @@ #define

Re: [sqlite] warning: ‘_popen’ redeclared without dllimport attribute

2013-08-15 Thread Stephan Beal
On Thu, Aug 15, 2013 at 3:42 PM, Jan Nijtmans jan.nijtm...@gmail.comwrote: /* Make sure isatty() has a prototype. */ extern int isatty(int); FILE *popen(const char*,const char*); int pclose(FILE*); Shouldn't those be +extern for consistency with isatty (or isatty not extern)? --

Re: [sqlite] warning: ‘_popen’ redeclared without dllimport attribute

2013-08-15 Thread Jan Nijtmans
2013/8/15 Stephan Beal sgb...@googlemail.com: Shouldn't those be +extern for consistency with isatty (or isatty not extern)? See: http://publications.gbdirect.co.uk/c_book/chapter8/declarations_and_definitions.html The default depends on whether the declaration is made outside a function

Re: [sqlite] warning: ‘_popen’ redeclared without dllimport attribute

2013-08-15 Thread Stephan Beal
On Thu, Aug 15, 2013 at 3:56 PM, Jan Nijtmans jan.nijtm...@gmail.comwrote: So, the C-language doesn't care, extern is the default anyway. For readability I would add extern to all definitions, but that's a matter of taste. Right - i meant as a matter of project-level consistency/taste. i

Re: [sqlite] SQLite Input with validation and lookup

2013-08-15 Thread Stephen Hughes
Thank you Simon for your very comprehensive and interesting reply, especially the SQL examples - set MAXIMUM/MINIMUM values. CREATE TABLE journeys ( start TEXT, destination TEXT, distance REAL, CHECK (distance BETWEEN 0.0 AND 5000.0), CHECK (start !=

Re: [sqlite] SQLite Input with validation and lookup

2013-08-15 Thread Stephen Hughes
Sorry if the following is a duplicate but I've just updated to the latest version of my email client and it seems to be leaving messages in the out-basket! Thank you Simon for your very comprehensive and interesting reply, especially the SQL examples - set MAXIMUM/MINIMUM values. CREATE TABLE

[sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

2013-08-15 Thread Gary Weaver
SQLite DB (file) corruption in travisci vm with 3.7.9 (latest they had available). Link to logs showing errors, code to reproduce here: https://github.com/travis-ci/travis-ci/issues/1334 Is there something in config, etc. that would help? ___

Re: [sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

2013-08-15 Thread Richard Hipp
On Thu, Aug 15, 2013 at 3:10 PM, Gary Weaver garyswea...@gmail.com wrote: SQLite DB (file) corruption in travisci vm with 3.7.9 (latest they had available). Link to logs showing errors, code to reproduce here: https://github.com/travis-ci/travis-ci/issues/1334 Is there something in config,

[sqlite] please help me; i need sqlite-netFx35-setup-bundle-x64-2008-1.0.84.0.exe

2013-08-15 Thread ??????ip/
hi : please help me i need sqlite-netFx35-setup-bundle-x64-2008-1.0.84.0.exe ,but i did not find the file from the internet ?? please send it to me . thanks !! ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

2013-08-15 Thread Gary Weaver
On Aug 15, 2013, at 3:20 PM, Richard Hipp d...@sqlite.org wrote: On Thu, Aug 15, 2013 at 3:10 PM, Gary Weaver garyswea...@gmail.com wrote: SQLite DB (file) corruption in travisci vm with 3.7.9 (latest they had available). Link to logs showing errors, code to reproduce here:

Re: [sqlite] SQLite Input with validation and lookup

2013-08-15 Thread David Bicking
I've never used Visual FoxPro, but I suspect that it allows you to create forms to insert data in to the database. Sqlite doesn't do that. Sqlite only provides the library to store the data via SQL statements that you execute via sqlite3_prepare()/sqlite3_step() function calls. You are

Re: [sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

2013-08-15 Thread Richard Hipp
On Thu, Aug 15, 2013 at 3:39 PM, Gary Weaver garyswea...@gmail.com wrote: Is there anything that stands out as something that would keep 30 processes from being able to concurrently insert into the same tables? Yes. SQLite does not (and has never) supported that. Multiple processes can

Re: [sqlite] please help me; i need sqlite-netFx35-setup-bundle-x64-2008-1.0.84.0.exe

2013-08-15 Thread Kevin Benson
On Thu, Aug 15, 2013 at 12:00 PM, 木与萱ip/ zsm...@qq.com wrote: sqlite-netFx35-setup-bundle-x64 http://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx35-setup-bundle-x64-2008-1.0.84.0.exe -- -- -- --Ô¿Ô-- K e V i N ___

Re: [sqlite] name resolutionn in GROUP BY

2013-08-15 Thread Richard Hipp
On Wed, Aug 14, 2013 at 12:22 PM, Rob Golsteijn rob.golste...@mapscape.euwrote: The behaviour of Sqlite of w.r.t. name resolving in group by caluses seems to have changed in the latest version. This might lead to errors in previously working SQL code, or worse, undetected changes in