[sqlite] Update from 3.6.23.1 to 3.7.10 : sqlite3_open16 error

2012-03-16 Thread Juan Perez
Hi all: I´m using SQLite amalgamation in my C++ (VS 2005) project. Latest release y use was 3.6.23.1 and it works perfectly. I decide to update to 3.7.10. It compiles perfectly but have a crash when I use sqlite3_open16. The code breaks at (sqlite3.c, line 35393): SimulateIOError

Re: [sqlite] Update from 3.6.23.1 to 3.7.10 : sqlite3_open16 error

2012-03-16 Thread Joe Mistachkin
Juan Perez wrote: > > It compiles perfectly but have a crash when I use sqlite3_open16. > The code breaks at (sqlite3.c, line 35393): > This is a known issue with the version of the Platform SDK that ships with Visual Studio 2005. Defining the _WIN32_WINNT macro (to a value like 0x0400) in the

Re: [sqlite] SQLite and Windows Metro Style

2012-03-16 Thread Philipp Kursawe
Good to read that a WinRT compatible version is on the way. I had struggle myself to get the current 3.7 code to compile without compiler complains about uncast assignments. Let alone the non-existent Win32 APIs in the WinRT environment. By the way there is already a compile time preprocessor defin

Re: [sqlite] SQLite and Windows Metro Style

2012-03-16 Thread Richard Hipp
On Fri, Mar 16, 2012 at 7:09 AM, Philipp Kursawe wrote: > Good to read that a WinRT compatible version is on the way. > I had struggle myself to get the current 3.7 code to compile without > compiler complains about uncast assignments. Let alone the non-existent > Win32 APIs in the WinRT environme

[sqlite] Core in sqlite3MemMalloc function

2012-03-16 Thread Ashutosh Tiwari
Hello All, I am using Sqlite 3_7_5 sqlite version, my application is crashed in this function (sqlite3MemMalloc) below is the gdb out put - #0 0x004d2e3f in _int_malloc () from /lib/libc.so.6 #1 0x004d4e97 in malloc () from /lib/libc.so.6 #2 0x001825fe in sqlite3MemMalloc (nByte=5947712) at s

Re: [sqlite] Sqlite error message

2012-03-16 Thread Waltênio de Bessa Mendes
Dear Simon, Thanks for help. I created a database named "Biblia" with a table named "LivroDaBiblia". I tried the shell tool and get the following. 2012/3/15 Simon Slavin > > On 15 Mar 2012, at 6:48pm, Waltênio de Bessa Mendes < > walteniobe...@gmail.com> wrote: > > > I need help when receive

Re: [sqlite] Core in sqlite3MemMalloc function

2012-03-16 Thread Richard Hipp
On Thu, Mar 15, 2012 at 8:23 AM, Ashutosh Tiwari wrote: > Hello All, > > I am using Sqlite 3_7_5 sqlite version, my application is crashed in this > function (sqlite3MemMalloc) below is the gdb out put - > > #0 0x004d2e3f in _int_malloc () from /lib/libc.so.6 > #1 0x004d4e97 in malloc () from /

Re: [sqlite] Update from 3.6.23.1 to 3.7.10 : sqlite3_open16 error

2012-03-16 Thread Juan Perez
Thank you very much Joe, it works perfectly! El 16 de marzo de 2012 11:10, Joe Mistachkin escribió: > > Juan Perez wrote: > > > > It compiles perfectly but have a crash when I use sqlite3_open16. > > The code breaks at (sqlite3.c, line 35393): > > > > This is a known issue with the version of the

[sqlite] [bug] inconsistency between #define compilte-time and isNT() run-time

2012-03-16 Thread AlexHr
Hello, I've just upgraded SQLite from version 3.6.22 to version 3.7.10 and now, all my programs crash at run-time. It's because, as mentioned before on this mailing-list by darkelf, there is an inconsistency between #define compilte-time and isNT() run-time. All my projects are compiled and use

Re: [sqlite] ABOUT IMPORT TXT FILE TO SQLITE

2012-03-16 Thread Kevin Benson
On Thu, Mar 15, 2012 at 10:16 PM, YAN HONG YE wrote: > On Date: Wed, 14 Mar 2012 23:13:57 -0400 > From: Kevin Benson > wrote: > > Quick solution to above error may be to try path with forward slashes: > I was referring to the error you reported BELOW ( SEE ARROW <\ ): NOT your attempt to en

Re: [sqlite] [bug] inconsistency between #define compilte-time and isNT() run-time

2012-03-16 Thread Woody
Woody "Im in shape, round is a shape!" Original message Subject: [sqlite] [bug] inconsistency between #define compilte-time and isNT() run-time From: AlexHr To: sqlite-users@sqlite.org CC: Hello, I've just upgraded SQLite from version 3.6.22 to version 3.7.10 and now

Re: [sqlite] [bug] inconsistency between #define compilte-time and isNT() run-time

2012-03-16 Thread Richard Hipp
On Fri, Mar 16, 2012 at 8:41 AM, AlexHr wrote: > > Hello, > > I've just upgraded SQLite from version 3.6.22 to version 3.7.10 and now, > all > my programs crash at run-time. > This is due to a bug in VS2005. You can work around it yourself by defining _WIN32_WINNT to 0x0400. We have a work-aro

Re: [sqlite] SQLite and Windows Metro Style

2012-03-16 Thread Philipp Kursawe
Hello > > How can I download the current WinRT efforts and compile them myself > into a > > WinRT component? > > > > Download the latest winRT code from > http://www.sqlite.org/src/timeline?r=winrt > > All I see there is a checkin history. Clicking on files does give me files but no tarbar or so

Re: [sqlite] SQLite and Windows Metro Style

2012-03-16 Thread Richard Hipp
On Fri, Mar 16, 2012 at 9:49 AM, Philipp Kursawe wrote: > Hello > > > > > How can I download the current WinRT efforts and compile them myself > > into a > > > WinRT component? > > > > > > > Download the latest winRT code from > > http://www.sqlite.org/src/timeline?r=winrt > > > > All I see there

Re: [sqlite] SQLite and Windows Metro Style

2012-03-16 Thread Philipp Kursawe
> > > Click to get to http://www.sqlite.org/src/info/cd70bc4b78 then look beside > "Other Links:" and click on either "Tarball" or "ZIP Archive". > > thanks! found it. Compiling without awk is not possible? ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Sqlite error message

2012-03-16 Thread Waltênio de Bessa Mendes
Dear Simon, I am trying other ways. To learn about command line shell I created the following example: * SQLite version 3.7.10 2012-01-16 13:28:40 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> sqlite3 alphaDB ...> create table contact(name TEXT, city TEXT); E

Re: [sqlite] Sqlite error message

2012-03-16 Thread Simon Slavin
On 16 Mar 2012, at 2:08pm, Waltênio de Bessa Mendes wrote: > I am trying other ways. To learn about command line shell I created the > following example: > * > SQLite version 3.7.10 2012-01-16 13:28:40 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> sqlit

Re: [sqlite] SQLite and Windows Metro Style

2012-03-16 Thread Richard Hipp
On Fri, Mar 16, 2012 at 10:05 AM, Philipp Kursawe wrote: > > > > > > Click to get to http://www.sqlite.org/src/info/cd70bc4b78 then look > beside > > "Other Links:" and click on either "Tarball" or "ZIP Archive". > > > > thanks! found it. Compiling without awk is not possible? > On my windows7 bo

Re: [sqlite] Sqlite error message

2012-03-16 Thread Waltênio de Bessa Mendes
Thanks! works fine! 2012/3/16 Simon Slavin > > On 16 Mar 2012, at 2:08pm, Waltênio de Bessa Mendes < > walteniobe...@gmail.com> wrote: > > > I am trying other ways. To learn about command line shell I created the > > following example: > > * > > SQLite version 3.7.10 2012-01-16 13:28:40 > > Ente

[sqlite] Update case in a transaction

2012-03-16 Thread Giuseppe Costanzi
Hi all, I would create a trigger to update a field in a table when in another table a new record is insert My scenario is products table product_id = INTEGER PK product = TEXT stock = INTEGER transactions table transaction_id = INTEGER PK product_id = INTEGER FK flow = BOOLEAN (0,1) quantitty =

Re: [sqlite] Update case in a transaction

2012-03-16 Thread Igor Tandetnik
On 3/16/2012 11:59 AM, Giuseppe Costanzi wrote: CREATE TRIGGER update_stocks AFTER INSERT ON transactions BEGIN UPDATE products SET products.stock =(CASE WHEN (transactions.flow =1 ) THEN SUM(products.stock + transactions.quan

Re: [sqlite] Update case in a transaction

2012-03-16 Thread Giuseppe Costanzi
On Fri, 2012-03-16 at 12:28 -0400, Igor Tandetnik wrote: > On 3/16/2012 11:59 AM, Giuseppe Costanzi wrote: > > CREATE TRIGGER update_stocks AFTER INSERT ON transactions > > BEGIN > > UPDATE products > > SET > > products.stock =(CASE > > WHEN (transactions.flow =1 ) >

Re: [sqlite] ABOUT IMPORT TXT FILE TO SQLITE

2012-03-16 Thread Kees Nuyt
On Fri, 16 Mar 2012 02:16:03 +, YAN HONG YE wrote: >On Date: Wed, 14 Mar 2012 23:13:57 -0400 >From: Kevin Benson >wrote: > >Quick solution to above error may be to try path with forward slashes: > >C:\sqlite\lib>".separator ',' \n .import /sqlite/lib/ddl.txt dzh \n" | >sqlite3 /sqlite/lib/fo

[sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Arnav Aggarwal
Hi, I am new to sqlite. I just downloaded the lates version of sqlite and was playing with various options. I want to link sqlite code with my application which is single threaded. So, I keep SQLITE_THREADSAFE=0. I use sqlite3_open_v2() to open the database. My question is what "vfs" (fourth a

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/03/12 20:34, Arnav Aggarwal wrote: > I want to link sqlite code with my application which is single > threaded. So, I keep SQLITE_THREADSAFE=0. I would recommend leaving it at the default. Any performance penalty is unlikely to even be measurab

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Arnav Aggarwal
On Sat, Mar 17, 2012 at 10:10 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 16/03/12 20:34, Arnav Aggarwal wrote: > > I want to link sqlite code with my application which is single > > threaded. So, I keep SQLITE_THREADSAFE=0. > > I would recommend leaving it at

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Richard Hipp
On Sat, Mar 17, 2012 at 1:08 AM, Arnav Aggarwal < arnav.aggarwal.2...@gmail.com> wrote: > On Sat, Mar 17, 2012 at 10:10 AM, Roger Binns > wrote: > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > On 16/03/12 20:34, Arnav Aggarwal wrote: > > > I want to link sqlite code with my applic

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Arnav Aggarwal
On Sat, Mar 17, 2012 at 10:42 AM, Richard Hipp wrote: > On Sat, Mar 17, 2012 at 1:08 AM, Arnav Aggarwal < > arnav.aggarwal.2...@gmail.com> wrote: > > > On Sat, Mar 17, 2012 at 10:10 AM, Roger Binns > > wrote: > > > > > -BEGIN PGP SIGNED MESSAGE- > > > Hash: SHA1 > > > > > > On 16/03/12

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Arnav Aggarwal
On Sat, Mar 17, 2012 at 10:42 AM, Richard Hipp wrote: > On Sat, Mar 17, 2012 at 1:08 AM, Arnav Aggarwal < > arnav.aggarwal.2...@gmail.com> wrote: > > > On Sat, Mar 17, 2012 at 10:10 AM, Roger Binns > > wrote: > > > > > -BEGIN PGP SIGNED MESSAGE- > > > Hash: SHA1 > > > > > > On 16/03/12

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/03/12 22:50, Arnav Aggarwal wrote: > I don't have any choice of using a different filesystem.. I'd suggest you write your own VFS then. You can choose exactly how locking is done. It isn't that much work and you can map to the exact semantics

Re: [sqlite] Do we need locking with multithread off ?

2012-03-16 Thread Arnav Aggarwal
On Sat, Mar 17, 2012 at 11:51 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 16/03/12 22:50, Arnav Aggarwal wrote: > > I don't have any choice of using a different filesystem.. > > I'd suggest you write your own VFS then. You can choose exactly how > locking is d