Re: [sqlite] sqlite Issue

2014-11-14 Thread Stephen Chrzanowski
If you're using SQLite3.exe (or equivalent CLI - Command Line Interface) then by default the database id written to memory, not to the disk. Doing something like [ sqlite3.exe test.db3] will create a test.db3 file once you do an actual transaction like creating a table. I THINK even doing a

Re: [sqlite] sqlite Issue

2014-11-14 Thread Simon Slavin
On 14 Nov 2014, at 10:40am, ARVIND KUMAR wrote: > I am new for SQLite. I am trying to create database. But its not creating. > I have attached the screenshot. Please find and do needful. You cannot post screenshots to this mailing list. Most problems with creating a

[sqlite] sqlite Issue

2014-11-14 Thread ARVIND KUMAR
Hi, I am new for SQLite. I am trying to create database. But its not creating. I have attached the screenshot. Please find and do needful. Thanks & Regards Arvind ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] sqlite issue when using AIX

2014-03-18 Thread Peter Simpson
Hi, Many thanks for the feedback and apologies for the delay in responding. As requested, I have downloaded 3.8.4.1 onto our AIX machine, and it works fine. Kind regards, Peter Simpson (Hopewiser) P.S. Did try and respond online but subscription request got rejected somewhere along the

Re: [sqlite] sqlite issue when using AIX

2014-03-05 Thread Richard Hipp
On Tue, Mar 4, 2014 at 11:00 AM, Peter Simpson wrote: > Hi, > > We are currently using SQLite 3.8.2. > > When using this on AIX, we encountered an issue with an "unsigned char" in > the sqliteProcessJoin procedure in sqlite3.c. > Can you please try the latest 3.8.4

Re: [sqlite] sqlite issue when using AIX

2014-03-05 Thread Ross Hayden
On Tue, Mar 4, 2014 at 10:00 AM, Peter Simpson wrote: > When using this on AIX, we encountered an issue with an "unsigned char" in > the sqliteProcessJoin procedure in sqlite3.c. > > For cases where "pSrc->nSrc" was 0, then "pSrc->nSrc-1" was being treated > as

Re: [sqlite] sqlite issue when using AIX

2014-03-05 Thread Clemens Ladisch
Peter Simpson wrote: > When using this on AIX, we encountered an issue with an "unsigned char". > > For cases where "nSrc" was 0, then "nSrc-1" was being treated as positive > (since nSrc is defined as an unsigned char, u8) This violates the C standard (any C standard). Does you compiler

[sqlite] sqlite issue when using AIX

2014-03-05 Thread Peter Simpson
Hi, We are currently using SQLite 3.8.2. When using this on AIX, we encountered an issue with an "unsigned char" in the sqliteProcessJoin procedure in sqlite3.c. The issue occurred with the following line (99798) :- for(i=0; inSrc-1; i++, pRight++, pLeft++){ For cases where