Re: [sqlite] Remove row to insert new one on a full database

2019-04-04 Thread Roger Schlueter
This looks to be an example of the classic XY Problem.  You are asking how to solve Problem X when what you're trying to do is solve Problem Y.  In this case, "X" is a full database, which is almost certainly an oxymoron since SQLIte can store millions of rows of data.  It is not clear what

Re: [sqlite] UPSERT with multiple constraints

2019-03-27 Thread Roger Schlueter
Following Simons' comment, changing the schema to conform to SQL expectations would involve having at least two tables.  Consider your second uniqueness criterion; Let's call those items a "Widget" so your Widget table would be: WIDGETS {A, B, C, .}  UNIQUE(A,B,C) Let's call your items

Re: [sqlite] Improving CSV import

2019-03-21 Thread Roger Schlueter
Or, better yet .header n where n=0   <--no header n>0  <-- number of header lines If .header is not specified then it defaults to zero so breaking backwards is not a concern. On 3/21/2019 19:04, Shawn Wagner wrote: I thought about suggesting that, but I can see it breaking backwards

Re: [sqlite] Variable Declaration

2019-01-19 Thread Roger Schlueter
before -> because to help those for whom English is not their first language. Cheers. On 1/19/2019 5:53, Simon Slavin wrote: On 19 Jan 2019, at 4:49am, Stephen Chrzanowski wrote: I know about the bindings. I don't know about all languages supporting it. Bindings are part of the SQLite

Re: [sqlite] SQLite Application Question

2018-12-20 Thread Roger Schlueter
keep track of changes in your own code? Thanks a lot for your time; I'm stretching to put this together ... which is part of the fun. Thanks, Chris On Thu, Dec 20, 2018 at 3:37 AM Roger Schlueter wrote: On 12/19/2018 10:02, Jens Alfke wrote: On Dec 18, 2018, at 7:46 PM, Roger Schlueter wr

Re: [sqlite] SQLite Application Question

2018-12-19 Thread Roger Schlueter
On 12/19/2018 10:02, Jens Alfke wrote: On Dec 18, 2018, at 7:46 PM, Roger Schlueter wrote: I am starting work on a prototype application so this might be an excellent opportunity to use SQLite for my application file format. Part of this would be the saving and restoring of GUI elements

[sqlite] SQLite Application Question

2018-12-18 Thread Roger Schlueter
I am starting work on a prototype application so this might be an excellent opportunity to use SQLite for my application file format.  Part of this would be the saving and restoring of GUI elements such as window positions and sizes, control states, themes, etc.  I can conceive of a few

Re: [sqlite] Regarding CoC

2018-10-19 Thread Roger Schlueter
There's no atheists/freethinkers at SQLite? If the second half of 54 is observed, it would be a dreary world indeed. Roger On 10/19/2018 10:30, Simon Slavin wrote: On 19 Oct 2018, at 6:26pm, Andrew Brown wrote: I looked it up, wondering what it would say, and I have to say, I love it.

Re: [sqlite] SQLite Windows GUI alternative to Excel?

2018-10-06 Thread Roger Schlueter
In addition to the freebies mentioned by Luuk, WordPerfect Office X9 is a commercial product that includes all of Excel's features including import/export of Excel data. https://www.wordperfect.com/en/product/office-suite/?hptrack=mmap On 10/6/2018 4:40, Winfried wrote: Hello, After

Re: [sqlite] Next release

2018-08-25 Thread Roger Schlueter
What about System.Data.SQLite? On 8/25/2018 13:04, Richard Hipp wrote: On 8/25/18, R Smith wrote: A quick dev question: Any idea on the eta for the next release? My best guess at the moment is 4 or 5 weeks. ___ sqlite-users mailing list

Re: [sqlite] questions

2018-08-18 Thread Roger Schlueter
Hi Alex, This functionality is certainly something that SQLite or even any moderately capable database system can solve.  However, for these specific requirements there is very likely no off-the-shelf, ready-to-go solution unless the requirement is very common or regulatory-required in your

[sqlite] Using Chinook

2018-08-13 Thread Roger Schlueter
I am just starting to learn SQLite so I am afraid my questions here will be quite simple for a (very long?) while compared to those I have been reading.  I'm starting by trying to follow the tutorial. I have SQLite, the GUI, and chinook.db installed on Windows 10 but not in the default

[sqlite] SQLite.NET Class Library Documentation Feedback: Designer Support

2018-07-09 Thread Roger Schlueter
SQLite.NET Help     Introduction to System.Data .SQLite         Initializing Design-Time Support             Express Edition Limitations This whole section should be removed since it is no longer correct, especially the part in red.  If you want to include the versions of Visual Studio just

[sqlite] Use with Visual Studio

2018-07-08 Thread Roger Schlueter
I am considering using the .net version of SQLite but have two questions: 1. The documentation lists the versions of Visual Studio that are supported.  VS2017 is NOT listed.  Is VS2017 supported. 2. The documentation states "Due to Visual Studio licensing restrictions, the Express Editions