[sqlite] Reserved column names

2016-03-21 Thread Dominique Devienne
On Sat, Mar 19, 2016 at 11:56 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > My rule of thumb is to always quote (using square brackets) when the > query is generated by code, and only quote where reasonable when the > query is written by a human. > Seems like using

[sqlite] Reserved column names

2016-03-21 Thread Cezary H. Noweta
Hello, On 2016-03-21 08:57, Dominique Devienne wrote: > Seems like using square-brackets instead of double-quotes is non-standard: > https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Data_structure_definition/Delimited_identifiers Explicitly documented by SQLite:

[sqlite] Linux .so files for 3.12

2016-03-21 Thread jeremydcn
hi, I am new to the list so will demonstrate ignorance right of the bat. have compiled 3.12 from source under Ubuntu 14.04 x86 and all good. recursion works as advertised. for something like sqliteman or sqlitemanager (i feel the shame) and maybe other packages they don't seem 3.12 aware even

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread Klaas Van B.
>> On 3/19/16, James K. Lowden wrote: >> ... If the correctness of the code is >> subject to change by the compiler's interpretation of the language, how >> is the programmer to prevent it? > On Sat, 19 Mar 2016 15:50:43 -0400 Richard Hipp wrote: > ... But subsequent revisions of the >

[sqlite] Reserved column names

2016-03-21 Thread Dominique Devienne
On Mon, Mar 21, 2016 at 11:01 AM, Cezary H. Noweta wrote: > On 2016-03-21 08:57, Dominique Devienne wrote: > >> Seems like using square-brackets instead of double-quotes is non-standard: >> >> https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Data_structure_definition/Delimited_identifiers >>

[sqlite] Possible bug in the SQL parser

2016-03-21 Thread João Ramos
Sorry for the late reply. That output (--1 etc.) was me manually "formatting" the results. I came across this issue using SQLiteStudio v3.0.7 on Windows. I just create a new DB and run that script: it outputs two rows, with one column each, with the values 1 and 2 respectively, instead of an

[sqlite] Reserved column names

2016-03-21 Thread Stephen Chrzanowski
AFAIK, SQLite comes from the grass roots of PostgreSQL. Whatever 'standards' it adheres to, SQLite goes by. As a fact, I don't know what those standards are, and I don't care what they are. The documentation on SQLite.org says "This is how you use it", so that's how I'll use it. Besides,

[sqlite] Linux .so files for 3.12

2016-03-21 Thread Simon Slavin
On 20 Mar 2016, at 10:35pm, jeremydcn wrote: > for something like sqliteman or sqlitemanager (i feel the shame) and maybe > other packages they don't seem 3.12 aware even though I have put a symlink > named sqlite3 pointing to sqlite3.12 in /usr/bin and there are no other > sqlite3 on the

[sqlite] windows 10 with System.Data.SQLite

2016-03-21 Thread Hinrich Aue
Hello list, we are using System.Data.SQLite 1.0.80.0 in our product. Does this version support windows 10? Thx, Hinrich Hinrich Aue Sr. Software Engineer Kofax Development GmbH Wentzinger Strasse 19 79106 Freiburg Germany Tel: +49 761 452 69 57234 Fax: +49 761 452 69 58734 Hinrich.Aue at

[sqlite] windows 10 with System.Data.SQLite

2016-03-21 Thread Joe Mistachkin
Hinrich Aue wrote: > > we are using System.Data.SQLite 1.0.80.0 in our product. > Does this version support windows 10? > First of all, version 1.0.80.0 is almost 4 years old now and MANY improvements have been made since then, including bug fixes. The current release is 1.0.99.0. If

[sqlite] Reserved column names

2016-03-21 Thread Dominique Devienne
On Mon, Mar 21, 2016 at 12:18 PM, Stephen Chrzanowski wrote: > AFAIK, SQLite comes from the grass roots of PostgreSQL. Whatever > 'standards' it adheres to, SQLite goes by. As a fact, I don't know what > those standards are, and I don't care what they are. The documentation on > SQLite.org

[sqlite] keep out focus

2016-03-21 Thread hfiandor
Dear sirs> I have a button previously focused. When the action was completed and the promt was sended to other position in the MainMenu, the button remain indicating the focus. Please, I want to know how to unfocus the button. Thanks in advance, yours Ing. H?ctor F. Fiandor Rosario

[sqlite] Reserved column names

2016-03-21 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 21/03/16 03:32, Dominique Devienne wrote: > SQLite tries to be compatible with non-standard extensions from > various popular RDBMS', but when a standard alternative exists, it > should be preferred IMHO. --DD That depends on the code and project.

[sqlite] FTS tokenize=unicode61: "full" or "simple" case folding?

2016-03-21 Thread Tomash Brechko
Hello, https://www.sqlite.org/fts3.html#tokenizer page says that unicode61 tokenizer implements _full_ case folding (it doesn't emphasize the word, but it's there). ftp://unicode.org/Public/6.1.0/ucd/CaseFolding.txt has the following rules: -- cut -- ... 00DF; F; 0073 0073; # LATIN SMALL LETTER

[sqlite] FTS tokenize=unicode61: "full" or "simple" case folding?

2016-03-21 Thread Richard Hipp
On 3/21/16, Tomash Brechko wrote: > Hello, > > https://www.sqlite.org/fts3.html#tokenizer page says that unicode61 > tokenizer implements _full_ case folding (it doesn't emphasize the word, > but it's there). That is a documentation error. It has now been fixed. Thanks. Probably the error

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread Scott Perry
On Mar 21, 2016, at 3:17 AM, Klaas Van B. wrote: > >>> On 3/19/16, James K. Lowden wrote: > >>> ... If the correctness of the code is >>> subject to change by the compiler's interpretation of the language, how >>> is the programmer to prevent it? > >> On Sat, 19 Mar 2016 15:50:43 -0400

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread Scott Perry
On Mar 21, 2016, at 1:48 PM, Scott Perry wrote: > > On Mar 21, 2016, at 3:17 AM, Klaas Van B. wrote: >> On 3/19/16, James K. Lowden wrote: >> ... If the correctness of the code is subject to change by the compiler's interpretation of the language, how is the programmer to

[sqlite] FTS tokenize=unicode61: "full" or "simple" case folding?

2016-03-21 Thread Matthias-Christian Ott
On 2016-03-21 20:43, Tomash Brechko wrote: > Hello, > > https://www.sqlite.org/fts3.html#tokenizer page says that unicode61 > tokenizer implements _full_ case folding (it doesn't emphasize the word, > but it's there). ftp://unicode.org/Public/6.1.0/ucd/CaseFolding.txt has > the following rules:

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread Scott Robison
On Mar 21, 2016 2:48 PM, "Scott Perry" wrote: > > On Mar 21, 2016, at 3:17 AM, Klaas Van B. wrote: > > > >>> On 3/19/16, James K. Lowden wrote: > > > >>> ... If the correctness of the code is > >>> subject to change by the compiler's interpretation of the language, how > >>> is the programmer

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread James K. Lowden
On Mon, 21 Mar 2016 13:48:06 -0700 Scott Perry wrote: > Compilers allow you to choose your standard; --std=c11 means > something very specific (and unchanging) They do. And that covers what the standard covers. The standard also has limits. It includes constructs that are syntactically

[sqlite] Reserved column names

2016-03-21 Thread James K. Lowden
On Mon, 21 Mar 2016 11:32:28 +0100 Dominique Devienne wrote: > > Explicitly documented by SQLite: > > > > And? That's still non-SQL standard. > > SQLite tries to be compatible with non-standard extensions from > various popular RDBMS', but when a standard alternative exists, it > should be

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread J Decker
So far I just see analysis tools fail for the same sorts of valid code... this is a bit of C# but the same idea causes the same warnings and there's nothign tecniclally wrong with this. class test { struct large_struct { public int x; } bool arbitrary_true_false = true; void method()

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread Scott Doctor
you are missing using System; Scott Doctor scott at scottdoctor.com -- On 3/21/2016 5:21 PM, J Decker wrote: > So far I just see analysis tools fail for the same sorts of valid code... > > this is a bit of C# but the same idea causes the same warnings and > there's

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread J Decker
On Mon, Mar 21, 2016 at 8:40 PM, Scott Doctor wrote: > you are missing > > using System; whatever. It still fails because it says the variable is uninitilalized. THe only thing that doesn't is actually running it. That same pattern not matter what the language triggers warning/error checkers