Re: [sqlite] Database Version 2 or 3, can you query for it?

> Is it possible to query the database to see if it's 2.x or 3.x, we need to > know if the rowid's are 32 or 64 bit and we don't know what version we > might be running on? You can check the DB file header. The first 16 characters are "SQLite format 3\000" if it is version 3+ Check out

[sqlite] Database Version 2 or 3, can you query for it?

Is it possible to query the database to see if it's 2.x or 3.x, we need to know if the rowid's are 32 or 64 bit and we don't know what version we might be running on?

Re: [sqlite] A question about performance

--- Keith Herold <[EMAIL PROTECTED]> wrote: > Hi all; > > I know that nested queries in the FROM and WHERE clauses are compiled > and run just once. Is that true for the nested queries in the SELECT > clause as well? > > For example: > > SELECT firstname AS First, > (SELECT

Re: [sqlite] A question about performance

Distuinguish between compiled and executed. Sub-queries as expressions are always compiled exactly once. If the sub-query doesn't contain references to the outer query, it is executed the first time it is needed and the results cached. For example, if I have: CREATE TABLE ab(a, b); CREATE

Re: [sqlite] Does SQLite.NET not support AUTOINCREMENT

> ... can you tell me if this is correct SQL ... ? Yes, it's correct.

Re: [sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors

On Tue, 2005-03-01 at 12:37 -0500, D. Richard Hipp wrote: > On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote: > > I tried posting via gmane and was unsuccessful as this mailing list > > rejected the posting. I subsequently entered this ticket for evaluation. > > I tried combing the

Re: [sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors

On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote: > I tried posting via gmane and was unsuccessful as this mailing list > rejected the posting. I subsequently entered this ticket for evaluation. > I tried combing the list archives and the docs but found nothing that > would indicate

RE: [sqlite] Does SQLite.NET not support AUTOINCREMENT

Okay, I posted there, but can you tell me if this is correct SQL for the AUTOINCREMENT situation, SQLite3 didn't complain at all so I assumed it was okay? CREATE TABLE NewEmployees(EmployeeID INTEGER PRIMARY KEY AUTOINCREMENT, LastName TEXT, FirstName TEXT); > This question is probably better

Re: [sqlite] Does SQLite.NET not support AUTOINCREMENT

[EMAIL PROTECTED] wrote: I used this SQL: CREATE TABLE NewEmployees(EmployeeID INTEGER PRIMARY KEY AUTOINCREMENT, LastName TEXT, FirstName TEXT); and using SQLite3.exe did this SQLite3 employees.db .read create.sql .exit which created my database but no tools nor the SQLite.NET provider can read

RE: [sqlite] Does SQLite.NET not support AUTOINCREMENT

This question is probably better asked on the SQLite.NET sourceforge forum. By the way, I don't know the answer. Tim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, February 28, 2005 10:22 PM > To: sqlite-users@sqlite.org > Subject: [sqlite]

[sqlite] Restricting the range of unique ids.

Hello, Is there a way to restrict the unique ids to a desired range of values let's say only -ve values? One way I could think of was if we have an empty database with an entry as a maximum -ve value, then every insertion with unique id value NULL, will automatically keep incrementing by 1. Thus

RE: [sqlite] Good Graphical Tool for 3.x

Try: http://sqlite.org/contrib/download/sqlite3Explorer.zip?get=5 Regards, Uriel Carrasquilla "Tim McDaniel"

[sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors

I tried posting via gmane and was unsuccessful as this mailing list rejected the posting. I subsequently entered this ticket for evaluation. I tried combing the list archives and the docs but found nothing that would indicate that the failure of test was expected. Can someone please let me know.

[sqlite] Gname support is poor

The mailing gateway from gmane is not allowing postings. Is this intentional because the newsgroup is superior to this list. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

RE: [sqlite] ticket 1147

The user using your wrapper needs to be smart enough to know what he is doing. Your stuff should be merely the conduit not the editor. If I attempted to use a wrapper that "messed" with my SQL code, it would immediately be my ex-wrapper. Fred -Original Message- From: Tim McDaniel

RE: [sqlite] ticket 1147

> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: 28 February 2005 19:25 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] ticket 1147 > Wouldn't it be better to provide this information with a new > API rather than depend on a column naming convention?

Re: [sqlite] in-memory database and threads

Why sure Carly, no problem. ../bin/memdb create tables: 0.001289 load data: 0.046146 create indexes: 0.037478 Thread[0] 0.000319 Key[103407575] Date[20050107160130] Amount [64.94] Thread[0] 0.63 Key[103411009] Date[20050107200150] Amount [740.52] Thread[0] 0.52