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
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
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
? ...
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
? ...
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
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
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
- 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
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
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
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
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
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
13 matches
Mail list logo