Re: [sqlite] Speaking of Ruby & Sqlite...a weekend oddity for someone

2016-12-10 Thread Don V Nielsen
You are correct, sir. I discovered in the rake tasks the following little bit of code. It directs which version of sqlite to download and compile. # BINARY_VERSION = "3.8.11.1" # URL_VERSION= "3081101" # URL_PATH = "/2015" Now I just need to figure out how to reinitiate the rake

Re: [sqlite] Speaking of Ruby & Sqlite...a weekend oddity for someone

2016-12-09 Thread Roger Binns
On 09/12/16 14:09, Don V Nielsen wrote: > However, > it fails using the sqlite3 gem. The specific exception is "in > 'initialize': near "with": syntax error That will be a SQLite version issue - older SQLite's didn't support with. While you made some effort around versions, whatever is happening

[sqlite] Speaking of Ruby & Sqlite...a weekend oddity for someone

2016-12-09 Thread Don V Nielsen
I have an odd problem. It involves Linux & Windows, and it involves the ruby gem sqlite3. I've already contacted that author/maintainer of the gem, but I have not heard back in several weeks. I have a sql file that contains a ctas statement that employs cte with statements. On Windows, the sql