Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On Tue, Nov 8, 2011 at 7:11 PM, Richard Hipp wrote: > On Tue, Nov 8, 2011 at 7:08 PM, Gabor Grothendieck > wrote: > >> On Tue, Nov 8, 2011 at 6:46 PM, Richard Hipp wrote: >> > On Tue, Nov 8, 2011 at 5:50 PM, Gabor Grothendieck >> >

Re: [sqlite] Learning SQL using SQLite

On Wed, Nov 09, 2011 at 03:07:22AM +, Simon Slavin scratched on the wall: > > On 9 Nov 2011, at 2:55am, Arbol One wrote: > > > Hello everyone, I have downloaded the sqlite-amalgamation-3070900.zip > > file and I have > > incorporated

Re: [sqlite] WAL and local UNC filenames

Hi Pavel, I can't answer this question. Maybe it's something like all operations are successful but memory mapping is not actually shared between processes. So every process sees its own copy and assumes that no other process works with database, thus database can be corrupted in many possible

Re: [sqlite] WAL and local UNC filenames

What I've seen is that windows makes a local copy of the memory mapped file. Perhaps in swap. If you watch your application using "ProcMon" you can see all the disk IO. That's how I noticed the copy. For my usage, only one process opens the DB so, maybe it's a non-issue. C Tuesday,

Re: [sqlite] Learning SQL using SQLite

On 9 Nov 2011, at 2:55am, Arbol One wrote: > Hello everyone, I have downloaded the sqlite-amalgamation-3070900.zip > file and I have > incorporated the source code to a small program I am building. I want to use > SQLite as my database,

Re: [sqlite] WAL and local UNC filenames

On Mon, Nov 7, 2011 at 5:48 PM, Jean-Christophe Deschamps wrote: > Pavel, > >> This is not a local file. Even if you use your hostname as netname >> file is still retrieved through network stack. And I guess SAMBA >> doesn't work well with memory mapped files (in addition to

[sqlite] Learning SQL using SQLite

Hello everyone, I have downloaded the sqlite-amalgamation-3070900.zip file and I have incorporated the source code to a small program I am building. I want to use SQLite as my database, but I have little to nil knowledge of SQL, can anyone

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On 9 Nov 2011, at 12:08am, Gabor Grothendieck wrote: > If "SELECT ?50" allocates 50 * 72 bytes of memory then how > does that relate to SQLITE_MAX_VARIABLE_NUMBER? > SQLITE_MAX_VARIABLE_NUMBER did not seem to enter the calculation at > all. In the above case, SQLite was compiled with

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On Tue, Nov 8, 2011 at 7:08 PM, Gabor Grothendieck wrote: > On Tue, Nov 8, 2011 at 6:46 PM, Richard Hipp wrote: > > On Tue, Nov 8, 2011 at 5:50 PM, Gabor Grothendieck > > wrote: > > > >> In R, the RSQLite driver for SQLite

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On Tue, Nov 8, 2011 at 6:46 PM, Richard Hipp wrote: > On Tue, Nov 8, 2011 at 5:50 PM, Gabor Grothendieck > wrote: > >> In R, the RSQLite driver for SQLite currently has >> SQLITE_MAX_VARIABLE_NUMBER set to 999.  This is used by many people >> for many

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On Tue, Nov 8, 2011 at 5:50 PM, Gabor Grothendieck wrote: > In R, the RSQLite driver for SQLite currently has > SQLITE_MAX_VARIABLE_NUMBER set to 999. This is used by many people > for many different projects and on different platforms and it seems > that a number of

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On Tue, Nov 8, 2011 at 5:55 PM, Simon Slavin wrote: > > On 8 Nov 2011, at 10:50pm, Gabor Grothendieck wrote: > >> In R, the RSQLite driver for SQLite currently has >> SQLITE_MAX_VARIABLE_NUMBER set to 999.  This is used by many people >> for many different projects and on

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER

On 8 Nov 2011, at 10:50pm, Gabor Grothendieck wrote: > In R, the RSQLite driver for SQLite currently has > SQLITE_MAX_VARIABLE_NUMBER set to 999. This is used by many people > for many different projects and on different platforms and it seems > that a number of these projects want a larger

[sqlite] SQLITE_MAX_VARIABLE_NUMBER

In R, the RSQLite driver for SQLite currently has SQLITE_MAX_VARIABLE_NUMBER set to 999. This is used by many people for many different projects and on different platforms and it seems that a number of these projects want a larger number. Users don't compile this themselves so they are stuck

Re: [sqlite] select ... where [=] or [like]

> Thanks for your answer. > foocol contains a string of numbers. > The result of typeof(foocol) is text. And what's the result of hex(foocol) ? My guess is you have some extra non-printable characters in there. Pavel On Tue, Nov 8, 2011 at 12:11 PM, hmas wrote: > >

Re: [sqlite] select ... where [=] or [like]

Simon Slavin-3 wrote: > > > On 8 Nov 2011, at 10:58am, hmas wrote: > >> My application insert into a table a string of numbers (for exemple >> '98011295918220'. >> if I do (either from command line or from my c++ program) >> select foocol from footable where foocol = '98011295918220'

[sqlite] Documentation in PDF

Any one knows where I can get the documentation in http://www.sqlite.org/download.html, but in PDF format? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select ... where [=] or [like]

On 8 Nov 2011, at 10:58am, hmas wrote: > My application insert into a table a string of numbers (for exemple > '98011295918220'. > if I do (either from command line or from my c++ program) > select foocol from footable where foocol = '98011295918220' > the result set is empty I'm trying

[sqlite] select ... where [=] or [like]

select ... where [=] or [like] My application insert into a table a string of numbers (for exemple '98011295918220'. if I do (either from command line or from my c++ program) select foocol from footable where foocol = '98011295918220' the result set is empty but if I do select foocol