Re: [sqlite] Database opens OK but further calls result in MISUSE

On 6/23/05, James Arthur <[EMAIL PROTECTED]> wrote: > I've started with something fairly simple - opening and closing a database. > --- > rc = sqlite3_open("test.db", db) You are not passing the correct arguments to sqlite3_open. The compiler should have noticed this... If you are declaring the

Re: [sqlite] locking and retries in a multi-reader multi-writer environment

On 4/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi! SQLite 3.2.1 on win32. > > I'm having trouble wrapping my mind around where I have to be > paranoid about locking issues. In particular, the behavior when > readers and writers overlap, or two writers overlap, is not 100% > clear to

Re: [sqlite] SQLITE 3 Make install errors -- DESTDIR variableunpopulated,...

On Apr 12, 2005 8:10 PM, Reid Thompson <[EMAIL PROTECTED]> wrote: > D. Richard Hipp wrote: > > On Tue, 2005-04-12 at 11:53 -0400, Reid Thompson wrote: > >> This issues still exists: > >> http://www.mail-archive.com/sqlite-users@sqlite.org/msg06857.html > >> > >> reid > >> > > > > Perhaps someone

Re: [sqlite] Re: [Bulk] Re: [sqlite] How sqlite3_column_double works?

On Wed, 02 Feb 2005 19:10:58 -0300, Marcelo Zamateo <[EMAIL PROTECTED]> wrote: > Clay Dowling said: > > > > > double sqlite3_column_double(sqlite3_stmt*, int iCol); > > > > returns a double, not a pointer to a double. > > > Thank you Clay. > Excuse me, i'm not good programming in c. A double is 8

Re: [sqlite] problem with queries using group by

On Fri, 14 Jan 2005 18:15:04 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > Tiago Dionizio wrote: > > > Hi, > > > > I am using a recent copy from CVS and tried this: (sorry for the quick > > and dirty test) > > > > SQLite version 3.0.8 >

[sqlite] problem with queries using group by

Hi, I am using a recent copy from CVS and tried this: (sorry for the quick and dirty test) SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values(1); sqlite> select a from t group by a; SQL error: GROUP BY may only be used on aggregate queries

Re: [sqlite] collation sequence not used?

On Mon, 22 Nov 2004 08:00:08 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > Tiago Dionizio wrote: > > > > The collation sequence "binary" was not being used when i declared the > > column a without a type, but when i included the *text* type the &g

[sqlite] SQLite Book

I just found that there is a book about SQLite and thought you would like to know. link to page: http://www.quepublishing.com/title/067232685X Book Description SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a

Re: [sqlite] Formatting SQLite-query

I assume you are using wxWidgets.. why don't you consider using the specific functions for that purpose included in the wxString class? wxString::Format and wxString::FormatV Tiago On Mon, 25 Oct 2004 20:43:31 +0200, Steven Van Ingelgem <[EMAIL PROTECTED]> wrote: > Hi, > > I wanted to create

Re: [sqlite] No info on DEFERRED, IMMEDIATE, and EXCLUSIVE transactions

I believe this is what you are looking for: http://www.sqlite.org/lang.html#transaction Tiago On Sat, 23 Oct 2004 22:50:36 +0200, Tito Ciuro <[EMAIL PROTECTED]> wrote: > Hello, > > Sorry to post the question again, but after reading the "File Locking > And Concurrency In SQLite Version 3"

Re: [sqlite] Get a listing of tables

You can look at the command line sources and see which SQL statement is used to get that output (from .tables). Tiago On Tue, 12 Oct 2004 09:03:12 -0500, Bob Dankert <[EMAIL PROTECTED]> wrote: > Is there any way through a sql call to get a listing of tables in > sqlite? I tried '.tables' as

Re: [sqlite] blob length SUM command

select sum(length(col)) from t this should work, if i understand what you want. a a wrote: All, Is there a way to sum the blob lengths from a blob column without adding a "blob length" integer column? Would my architecture be more portable if I just added an integer "blob length" column? Mike

[sqlite] error handling when aborting from sqlite3_exec callback

When using the sqlite3_exec for executing queries, it is possible to abort execution from the callback (returning a number different than 0). If i do that, sqlite3_exec will return SQLITE_ABORT with no error message, and if i call sqlite3_errcode later it will tell me no error occurred and the

Re: [sqlite] Re: [sqlite3] Conditional jump or move depends on uninitialised value(s)

and valgrind doesn't complain anymore. Now i realize why i was getting segfaults. Thanks anyway. Tiago D. Richard Hipp wrote: Tiago Dionizio wrote: Using: SQLite 3 from cvs Fedora Core 2 gcc 3.3.3 I am currently working on trying to bind sqlite3 to Lua, and while testing things i encountered some

Re: [sqlite] host parameters / bind variables - further workouts

Michael Roth wrote: I create a prepared statement with this: local db = sqlite3.open("somefilename") local stmt_a = db:prepare("SELECT * FROM test WHERE id=?1") local stmt_b = db:prepare("XYZ ?1 XYZ ?2 XYZ ?1") local id = 123 local str = "Hello World" stmt_a:bind(id)