Hello !
Have you ever heard about user friendly "alias/shortcut" ?
Cheers !
> Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden"
> Subject: Re: [sqlite] Help needed for COPY
>Command.
>
> On Fri, 25 Mar 2016 17:18:16 +0100
> "Domingo Alvarez Duarte" wrote:
>
>
>>Why not have
Did you figure this out?
I have just come across the same problem in a 64 bit Office (Excel)
installation.
RBS
On Fri, Feb 19, 2016 at 1:31 PM, Montes C?mara, <
victor.montes at alicante-ayto.es> wrote:
> Hello,
>
> I've been using sqlite in vba6 for some years using RichClient3 framework
> of
Why cannot drop the table test?
sqlite> begin transaction;
sqlite> create virtual table test using fts5;
Error: vtable constructor failed: test
sqlite> commit;
sqlite>
sqlite> drop table test;
Error: vtable constructor failed: test
sqlite> .tables
test test_content test_docsize
On Sat, 26 Mar 2016 16:37:18 +0200
John Found wrote:
> Why cannot drop the table test?
>
> sqlite> begin transaction;
> sqlite> create virtual table test using fts5;
> Error: vtable constructor failed: test
> sqlite> commit;
> sqlite>
> sqlite> drop table test;
> Error: vtable constructor
On Saturday, 26 March, 2016 09:09, Eduardo Morras wrote:
Clearly the tables were created, however (see the output from .tables).
This *only* occurs if you wrap the "create virtual table" in an explicit
transaction but does not occur if an implicit transaction is used.
The tables are
And only when commit is used to end the transaction, an explicit rollback works
properly.
> On Saturday, 26 March, 2016 09:09, Eduardo Morras
> wrote:
>
> Clearly the tables were created, however (see the output from .tables).
>
> This *only* occurs if you wrap the "create virtual table" in
On Sat, 26 Mar 2016 16:08:33 +0100
Eduardo Morras wrote:
> On Sat, 26 Mar 2016 16:37:18 +0200
> John Found wrote:
>
> > Why cannot drop the table test?
> >
> > sqlite> begin transaction;
> > sqlite> create virtual table test using fts5;
> > Error: vtable constructor failed: test
> > sqlite>
I apologize if I am missing something elementary here. I cannot understand
why this index is not helpful.
CREATE TABLE [T1](
[C1] TEXT,
[C2] TEXT,
[C3] DATE);
CREATE INDEX [IndxT1C3]
ON [T1](
[C3] COLLATE [NOCASE]);
insert into t1 values
('aa','bb','2016-01-01'),
On 3/26/2016 6:12 PM, Denis Burke wrote:
> CREATE INDEX [IndxT1C3]
> ON [T1](
> [C3] COLLATE [NOCASE]);
> --
> after doing this:
> explain query plan
> select C1 from T1
> where C3='2016-01-02'
You are requesting a case sensitive comparison; a case insensitive index
cannot be used
No, it is working perfectly.
The index cannot be used because the equal (=) operator is collate BINARY.
If you want the column C3 to be not case sensitive you declare the table thusly:
.eqp on
create table t1
(
c1 text,
c2 text,
c3 text collate nocase
);
create index IndxT1C3 on T1(C3);
10 matches
Mail list logo