At 3:00 PM -0700 10/7/07, Adam Megacz wrote:
Hello. This is probably a stupid question, but...
Is there any way to include some phrase in a SELECT clause that will
match only the Nth-Mth rows of a table, for some values of N and M?
Note that ROWID isn't what I'm looking for -- if you delete ro
At 1:17 PM + 11/7/06, [EMAIL PROTECTED] wrote:
QUESTION 1: sqlite3_prepare_v2 is the merely the working name
for the new function. What should the official name be?
I like sqlite3_prepare_v2. It lets me know that it's very similar to
sqlite3_prepare, so lots of existing documentation sti
At 4:01 PM -0400 6/26/06, [EMAIL PROTECTED] wrote:
Peter Bierman <[EMAIL PROTECTED]> wrote:
At 2:20 PM -0400 6/26/06, [EMAIL PROTECTED] wrote:
>SQLite 3.3.0 can read and write all prior versions of SQLite
>databases. But SQLite 3.2.8 cannot read or write a database
>created
At 2:20 PM -0400 6/26/06, [EMAIL PROTECTED] wrote:
SQLite 3.3.0 can read and write all prior versions of SQLite
databases. But SQLite 3.2.8 cannot read or write a database
created by SQLite 3.3.0, unless you use
PRAGMA legacy_file_format=TRUE;
prior to creating the database, or unless you co
At 3:53 PM -0600 1/4/06, Aaron Laffin wrote:
On 1/4/06, Peter Bierman <[EMAIL PROTECTED]> wrote:
Related to a project I'm working on, it would be useful for me to be
able to open a database file via passing an already open file
descriptor to the sqlite open() call. sqlite3_ope
Related to a project I'm working on, it would be useful for me to be
able to open a database file via passing an already open file
descriptor to the sqlite open() call. sqlite3_openfd().
I need this because I'd prefer to resolve some filesystem permissions
access issues in a separate process f
At 1:54 PM -0500 11/1/05, [EMAIL PROTECTED] wrote:
Please let me restate the proposed change: I desire to change
SQLite so that it no longer distinguishes between integer and
real. The two concepts are merged into a unified "numeric"
type.
And because all number values are of the same type,
Actually, on SQLite, 'INTEGER PRIMARY KEY' does designate a special
type of autoincremented column.
The internal 64 bit rowid is used directly in that case, which is
essentially 'free' storage.
http://www.sqlite.org/faq.html#q1
http://www.sqlite.org/lang_createtable.html
http://www.sqlite.org
8 matches
Mail list logo