[sqlite] sqlite Issue
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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite Issue
On 14 Nov 2014, at 10:40am, ARVIND KUMAR arv...@sblsoftware.com 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 new database are because you failed to specify an appropriate folder/directory for the database file. Please make sure you have write access to the folder you specified. If you are writing your own program which calls the SQLite API, and it is not creating the database, the function will return a value which is not SQLITE_OK. Please tell us what value it is returning. If you are using the SQLite Shell Tool to create your database, and it is not working, please post the error message it generates. If you are using some other program besides the SQLite Shell Tool, then that program is written by a third party, not the SQLite team and the SQLite team can't do anything about your problem. However, if you tell us what program you're using and what error message it shows we /might/ be able to advise you on what to try next. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite Issue
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 select will make the file as well. If you're writing code in some language, as Simon suggested, ensure that you're not writing to [ :memory: ] or to a directory that the app has create and write permissions. On Fri, Nov 14, 2014 at 5:40 AM, ARVIND KUMAR arv...@sblsoftware.com wrote: 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 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
[sqlite] sqlite issue when using AIX
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 line, hence my resorting to replying by email. _ Hopewiser Ltd, Merlin Court, Atlantic Street, Altrincham, WA14 5NL Reg in England, number 1621544 Tel: 0161 924 2800, Fax: 0161 924 2809, Web: http://www.hopewiser.com/ The information contained in this email is intended only for the named recipient(s) and may be confidential and/or privileged. Unauthorised use or reproduction (including storage or re-distribution in any media) is prohibited. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite issue when using AIX
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; ipSrc-nSrc-1; i++, pRight++, pLeft++){ For cases where pSrc-nSrc was 0, then pSrc-nSrc-1 was being treated as positive (since nSrc is defined as an unsigned char, u8), and the for loop was inadvertently being entered. To overcome this, we have resorted to casting the relevant code as follows :- for(i=0; i((int)pSrc-nSrc)-1; i++, pRight++, pLeft++){ Apologies if this has already been reported. I did check through the current tickets searching for AIX, and didn't find anything so I'm assuming that it hasn't already been reported. Regards, Peter Simpson (Hopewiser) _ Hopewiser Ltd, Merlin Court, Atlantic Street, Altrincham, WA14 5NL Reg in England, number 1621544 Tel: 0161 924 2800, Fax: 0161 924 2809, Web: http://www.hopewiser.com/ The information contained in this email is intended only for the named recipient(s) and may be confidential and/or privileged. Unauthorised use or reproduction (including storage or re-distribution in any media) is prohibited. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite issue when using AIX
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 (whatever it is) claim conformance to a standard? Might this be just some optimization bug? Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite issue when using AIX
On Tue, Mar 4, 2014 at 10:00 AM, Peter Simpson peter.simp...@hopewiser.comwrote: 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 positive (since nSrc is defined as an unsigned char, u8), and the for loop was inadvertently being entered. Peter Simpson (Hopewiser)] If you're using IBM's own compilers, specify xlc as your compiler (CC=xlc ./configure). The default behaviors of good old cc can be a bit dated. -- Ross ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite issue when using AIX
On Tue, Mar 4, 2014 at 11:00 AM, Peter Simpson peter.simp...@hopewiser.comwrote: 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 beta on AIX for us, and verify that the problem is now fixed. We (the SQLite developers) do not ourselves have access to an AIX machine for testing. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users