Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

2015-01-23 Thread Mike Nicolino
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Stephen Chrzanowski Sent: Friday, January 23, 2015 1:07 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable In the 8.3 days, I routinely gave directories

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

2015-01-23 Thread Stephen Chrzanowski
nal Message- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Hick Gunter > >Sent: Thursday, 22 January, 2015 01:39 > >To: 'General Discussion of SQLite Database' > >Subject: Re: [sqlite] System.Data.

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

2015-01-22 Thread Keith Medcalf
sday, 22 January, 2015 01:39 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] System.Data.SQLite - Exception Calling >SQLiteModule.DeclareTable > >I have always wondered why people will insist on using human readable >column names (with embedded spaces and special

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

2015-01-21 Thread Hick Gunter
etreff: Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable Figured this one out. DeclareTable doesn't like any 'quoting' around the column names in the sql. It works fine with just straight column names. -Original Message- From: sqlite-users-boun...@

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

2015-01-21 Thread Mike Nicolino
, January 17, 2015 6:17 PM To: sqlite-users@sqlite.org Subject: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable I'm getting an exception calling SQLiteModule.DeclareTable that seems to imply the 'create table' sql being passed is invalid: "SQL logic error or mi

[sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

2015-01-17 Thread Mike Nicolino
I'm getting an exception calling SQLiteModule.DeclareTable that seems to imply the 'create table' sql being passed is invalid: "SQL logic error or missing database". Yet using that same sql on the same connection as a create table call succeeds. Reviewing the virtual table docs don't imply