Re: [sqlite] BUG using DELETE query with AND clause

Ticket: https://www.sqlite.org/src/info/ef36060112a50591 On 8/26/16, Алексей Черных wrote: > DELETE statement has no effect on existing data, if AND clause used and > values > are in ' escape chars. > > OS: Ubuntu 16 (updated) > > #sqlite3 -version > #3.11.0 2016-02-15

[sqlite] BUG using DELETE query with AND clause

DELETE statement has no effect on existing data, if AND clause used and values are in ' escape chars. OS: Ubuntu 16 (updated) #sqlite3 -version #3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f Bug is reproduced in our database with a hundred of tables, but it is easy to

Re: [sqlite] sqlite importing csv

many thanks again for the replies and sorry I was amiss in not stating that it was sqlite3 DXCC.db, I was using the .db suffix but to no avail, however the problem has been that I was not getting it into the right folder to enter the import command. Thanks Bill you hit it on the nose,

Re: [sqlite] Locking databases - Possibly (probably?) a dumb question

On 08/20/2016 01:01 PM, Simon Slavin wrote: > On 20 Aug 2016, at 5:56pm, Lev wrote: [snip] >> So this 'setting' is stored in the database file? Is it enough to do the >> PRAGMA when the database is created? > > Yes and yes, but do it this way. > > 1) Create the database

Re: [sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

On 8/24/16, Richard Newman wrote: > sqlite> SELECT DISTINCT inner.uri AS uri FROM >...> (SELECT DISTINCT v AS uri FROM bar) >...> inner; > Error: near ";": syntax error > "Inner" is a keyword. You can put it in double-quotes to let SQLite know that you want to use

Re: [sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

Please retry your test without using keywords like "inner" as an alias for something. regards, Adam On Wed, Aug 24, 2016 at 11:26 PM, Richard Newman wrote: > Hi folks, > > According to my reading of < > https://www.sqlite.org/syntax/table-or-subquery.html>, a table alias

[sqlite] System.Data.SQLite and Entity framework 5

Is there a way to work with System.Data.SQLite with Entity framework 5? Latest version for .net framework 4.5 requires EF6, bit I need to work with EF5. Thanks! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

Hi folks, According to my reading of < https://www.sqlite.org/syntax/table-or-subquery.html>, a table alias for a subquery does not require an AS; that is, SELECT noo.foo FROM ( SELECT … FROM bar ) AS noo is equivalent to SELECT noo.foo FROM ( SELECT … FROM bar ) noo This does not seem to

Re: [sqlite] sqlite importing csv

Various notes -At the prompt, running "sqlite3 DXCC" is starting the sqlite3 program, and telling it to open the file named "DXCC" as its database. If it's not given a full path then it opens it in the directory the command prompt is in when you run it. If the file you give it doesn't exist,

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

Mr. Jensen, Thank you for the link - Although I am moving away from MS VS (I am using Dev-C++ more than MS VS) I have installed your MS VS Add-on so hopefully I will be able to use it soon. Thank you again Delvin -Original Message- From: sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

As an alternative to the System.data.sqlite design tools (depending on your requirements) you can use my free VS extension "SQLite Toolbox" https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/ Mvh / Regards Erik Ejlskov Jensen http://twitter.com/erikej

Re: [sqlite] sqlite importing csv

After opening your command prompt type: cd C:\jt65logger Then start SQLite and try importing your csv file. I see JT65 and DXCC, so I know this is ham related. Contact me directly if you'd like to discuss the ham aspects of your project. -- Bill Drago - W2KWD Staff Engineer L3 Narda-MITEQ 435

Re: [sqlite] sqlite importing csv

On 2016/08/25 9:35 AM, Alan wrote: Simon, I entered what you asaked and no, that file is in the users\John directory so I guess that the cmd sqlite3 DXCC is not shifting the focus to the directory that the DXCC database is in and i would need to be using some other set of commands to

Re: [sqlite] sqlite importing csv

By the way I have a folder C:\jt65Logger that contains all the databases etc to do with the project. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

Simon, I entered what you asaked and no, that file is in the users\John directory so I guess that the cmd sqlite3 DXCC is not shifting the focus to the directory that the DXCC database is in and i would need to be using some other set of commands to make that happen Alan On 25-Aug-16

Re: [sqlite] sqlite importing csv

after clicking on the command it is in C:\users\john after typing sqlite3 DXCCit shows sqlite> if I then enter cd it shows ...> On 25-Aug-16 18:01, Simon Slavin wrote: On 25 Aug 2016, at 6:59am, Alan wrote: I right Clicked on start and selected the windows

Re: [sqlite] sqlite importing csv

I was just going to suggest that - if it is the default directory - windows will start the command prompt in the C:\users\. As long as the csv file is in this directory (but more than likely it is in the C:\users\\Documents directory. Delvin -Original Message- From: sqlite-users

Re: [sqlite] sqlite importing csv

On 25 Aug 2016, at 6:59am, Alan wrote: > I right Clicked on start and selected the windows cmd, and as I understand > it at the moment > > by typing sqlite3 DXCC then it should be sitting in the directory or folder > that the DXCC database is in I don't think this is