-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BareFeet wrote:
> I'm on the verge of releasing a new GUI app for SQLite. I would like to
> include some SQLite template files other than my own.
I'd suggest having them on a web site wiki style so that people can
update and download them that way.
On Sat, Mar 27, 2010 at 04:44:56PM +0800, Tim scratched on the wall:
> Hi Donald,
>
> Thanks for your information. And I don't know how to reach Jay kreibich's
> email address, so I CC this mail to 'General Discussion of SQLite Database'.
>
> Could you please help me forward to Jay Kreibich if
Hello,
http://www.sqlite.org/lang_corefunc.html, in the description of "abs",
says: "If X is the integer -9223372036854775807 then abs(X) throws an
integer overflow error since there is no equivalent positive 64-bit
two complement value."
However, 9223372036854775807 can be represented as a
sqlite3_changes() and sqlite3_total_changes() both return an int.
I ran a huge update on a table with 2147483685 rows in it, and when I was done,
the result from sqlite3_total_changes() was negative, it had overflowed to
-2147483612.
The documentation doesn't seem to indicate negative values
On 27 Mar 2010, at 1:51pm, Greg Bryant wrote:
> From any of the various SQLite admin tools, I can type PRAGMA
> table_info(mytable) and I get a result set back with everything I need.
>
> However, when I move this into my code (we use a front-end class on the
> built-in MSVC SQL wrapper),
I'm trying to set up a general db update routine, since the app I'm working
on may change the database at any time, by changing a column type, adding or
removing a column. Since only one of those things is supported with alter
table, I'm just doing a modification of the "make a temp table, copy
Dan,
Thanks for the (ultra)fast fix! :-)
-
[9e075e70f0] Leaf Increase the estimated cost of using a virtual table as
the outer loop of a join when there exists an ORDER BY clause that is not
satisfied by the virtual table. Fix for 775b39dd3c. (user: dan, tags: trunk)
09:11 Ticket
On 27 Mar 2010, at 10:46am, GeoffW wrote:
> Just for educational purposes I have been experimenting a little with the
> Northwind Sqlite database contained on the sqlite official site.
> Download link: http://download.vive.net/Northwind.zip.
>
> Am I misunderstanding here or are the dates in
Hi Tom,
>BTW- if you haven't done so already; it may be of use to the user to add
>extensions: VirtualText and Jean-Christophe Deschamps has an extension
>for fuzzy search for example.
There is no problem. Alexey put it on his website under the extension
for Unicode folder. Please drop me a
Hi Tom,
> One feature of this software is its ability to facilitate data entry in views
> (ie not just tables). So I am especially interested in SQLite files that make
> use of views, triggers, relationships etc. Some simple, some advanced.
>
> Can you direct me to were I might find some useful
Hi
Just for educational purposes I have been experimenting a little with the
Northwind Sqlite database contained on the sqlite official site.
Download link: http://download.vive.net/Northwind.zip.
Am I misunderstanding here or are the dates in the wrong format for sqlite
within this converted
> ### PROBLEM
>
> With Sqlite 3.6.17 the following query executes in 12ms.
>
> ---
> SELECT a.number
> FROM a, fts
> WHERE
> a.number=fts.docid
> ORDER BY a.date desc
> LIMIT 20
> ---
>
>
> With Sqlite version 3.6.23 the same
Hi Donald,
Thanks for your information. And I don't know how to reach Jay kreibich's
email address, so I CC this mail to 'General Discussion of SQLite Database'.
Could you please help me forward to Jay Kreibich if he cannot receive it.
For the *easiest* way, I tried by turning off the journal
Hi all,
I'm on the verge of releasing a new GUI app for SQLite. I would like to include
some SQLite template files other than my own. These templates will act as a
starting point for the user to enter data and/or modify the schema as needed.
One feature of this software is its ability to
14 matches
Mail list logo