Re: [sqlite] Basic SQLite/EF6 question

2014-07-09 Thread Steven Davisworth
Joe Mistachkin writes: > > > William Drago wrote: > > > > Yes, and I can see my tables, etc. too. > > > > Ok. One thing to try is to GAC the System.Data.SQLite.EF6 assembly > (which may require GAC'ing the Entity Framework 6 assembly as well). > > Per the rules for distributing Entity Framew

Re: [sqlite] SQLite JDBC column count

2014-07-09 Thread Manoj
I do understand its a bad DB design and i should be actually doing what you have mentioned. But as mentioned in SQLite site it is possible to increase column limit during compile time. So i just need to know out of curiosity how it can be done in SQLite jar (jdbc) 3.7.2? -- View this message in

Re: [sqlite] Can't make SQLite work

2014-07-09 Thread mm.w
thx to teach me-self about the port LOL On Wed, Jul 9, 2014 at 3:03 PM, mm.w <0xcafef...@gmail.com> wrote: > ? ... > > > On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin > wrote: > >> >> On 7 Jul 2014, at 4:21am, mm.w <0xcafef...@gmail.com> wrote: >> >> > as we start low a more simple solution if

Re: [sqlite] Can't make SQLite work

2014-07-09 Thread mm.w
? ... On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin wrote: > > On 7 Jul 2014, at 4:21am, mm.w <0xcafef...@gmail.com> wrote: > > > as we start low a more simple solution if recent features are needed > > Nothing to do with MacPorts is simple. > > If you've messed up your shell path and 'which sq

Re: [sqlite] Can't make SQLite work

2014-07-09 Thread mm.w
? ... On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin wrote: > > On 7 Jul 2014, at 4:21am, mm.w <0xcafef...@gmail.com> wrote: > > > as we start low a more simple solution if recent features are needed > > Nothing to do with MacPorts is simple. > > If you've messed up your shell path and 'which sq

Re: [sqlite] column affinity and the query planner's use of indices

2014-07-09 Thread Hinrichsen, John
According to the documentation, when creating a table "AS SELECT ...", the "affinity of comparison operands" rules are applied; what I am suggesting is that these rules be extended when used with "CREATE TABLE ... AS SELECT ..." http://www.sqlite.org/datatype3.html#expraff 3.2 Affinity Of Comparis

Re: [sqlite] JDBC and savepoints

2014-07-09 Thread Pepijn Van Eeckhoudt
The Xerial JDBC driver does not if I recall correctly. There’s no reason why it couldn’t, the developers just didn’t implement it. Perhaps you should file an enhancement request in their issue tracker requesting it be implemented. If you don’t need nested transactions then you can get a single be

Re: [sqlite] Questions from a novice - basic browsing of records in a listview.

2014-07-09 Thread Clemens Ladisch
- wrote: > After having used the OFFSET and LIMIT 1 method (in conjuction with a > userdata listview) and finding a past post into this forum describing it as > a rookie mistake I'm now trying to implement the "scrolling cursor" method > in that same post. Are you using a list view, or paging? Th

Re: [sqlite] Questions from a novice - basic browsing of records in a listview.

2014-07-09 Thread Simon Slavin
On 9 Jul 2014, at 2:03pm, - wrote: > 1) Is it possible to refer to the columns in a kind of shorthand (index > perhaps) ? > > 2) Is it possible to have the SQLite engine initialize and remember certain > WHERE and ORDER clauses (without creating another database please :-) ), so > they can be u

Re: [sqlite] Planner chooses incorrect index

2014-07-09 Thread João Ramos
When I can I'll try with the latest release. Thanks for all your help. On Tue, Jul 8, 2014 at 4:05 PM, Dan Kennedy wrote: > On 06/25/2014 04:44 PM, João Ramos wrote: > >> The sample column has some sensitive data that I can't share, so I'll have >> to change it and then try to reproduce the pr

Re: [sqlite] Questions from a novice - basic browsing of records in a listview.

2014-07-09 Thread Philip Bennefall
How about using prepared statements in conjunction with bind? http://www.sqlite.org/c3ref/bind_blob.html Kind regards, Philip Bennefall On 2014-07-09 15:03, - wrote: Hello all, I'm quite new at SQLite3, and have a bit of a problem with grasping the handling of a database. After having used

[sqlite] Questions from a novice - basic browsing of records in a listview.

2014-07-09 Thread -
Hello all, I'm quite new at SQLite3, and have a bit of a problem with grasping the handling of a database. After having used the OFFSET and LIMIT 1 method (in conjuction with a userdata listview) and finding a past post into this forum describing it as a rookie mistake I'm now trying to implemen

Re: [sqlite] documentation bugs

2014-07-09 Thread Dan Kennedy
On 07/09/2014 01:45 PM, Laurent Dami wrote: * In http://www.sqlite.org/src/wiki?name=Bug+Reports , the href to the bug list is http://www.sqlite.org/src/report; should be http://www.sqlite.org/src/reportlist * In vtab.hml: the description of sqlite3_index_info is not up to date (missing esti