Hello !
Is it possible to expose commands to create/remove prefix indexes ?
Something like (or any other friendly way to do it without reindex the whole
database): INSERT INTO ft(ft) VALUES('remove prefix 2 3'); INSERT INTO
ft(ft) VALUES('remove prefix 2'); INSERT INTO ft(ft)
Tim Stowell wrote:
>
> var queryable = table.Skip(20); // Incorrect SQL
generated
>
Are you using the latest System.Data.SQLite?
Do you have an example of the generated SQL?
--
Joe Mistachkin
I?m using SQLite with .NET and LINQ. When I call Skip on an IQueryable, the
generated SQL uses ?TOP? instead of ?Limit? which is causing an error due to
SQLite not supporting the Top keyword. I have referenced both
System.Data.SQLite, System.Data.SQLite.Linq, and System.Data.Linq in the Visual
Hi All,
Thank you so much for your answers.
The Copy command that i have mentioned was found in below link:
https://www.sqlite.org/tclsqlite.html#copy
But just realized that it is in tcl interface. I overlooked it earlier :(
I have tried .import and its working for command line interface. But
Am 19.02.2016 um 14:31 schrieb Montes C?mara, Victor:
> I've been using sqlite in vba6 for some years
> using RichClient3 framework of Olaf Schmidt (www.datenhaus.de)
The new site (which offers a new version of the RichClient,
as well as new versions of __stdcall-compiled SQLite... as
e.g.
On 28 Mar 2016, at 6:49am, Mahi Gurram wrote:
> I have tried .import and its working for command line interface. But i need
> to do a bulk import (copy data from file into table) from c interface.
Sorry, but SQLite has no facilities for handling text files. It reads and
writes to its own
You need to handle the load yourself. Since you are talking bulk load, a
scripting language is probably out of the question because they are too
slow. I used C# with the System.Data.Sqlite binary.
The db handling you need to worry about is the following:
connection to db
prepare an insert
On 28 Mar 2016, at 1:27am, David Rayna wrote:
> I got excited when I saw the "indexed by" clause.
> A technique I used years ago with FoxPro & etc was to allow each user to
> create his own personal index of the same data.
> FoxPro allowed storing index files separately and on each user's own
On 28 Mar 2016, at 1:35am, David Rayna wrote:
> One thing I have occasionally desired is be able to search a table of
> patterns given a string that might match some rows.
> This is the reverse of searching a table of strings to find ones that match a
> pattern.
One usually sees
SELECT id
9 matches
Mail list logo
