Re: [sqlite] sqlite3 dll symbols

Dennis Jenkins wrote: Essien Essien wrote: hiya, I have a code snippet that looks like: typedef int (*SQLITE3_CLOSE)(sqlite3*); typedef const char* (*SQLITE3_ERRMSG)(sqlite3*); typedef int (*SQLITE3_OPEN)(const char*, sqlite3**); typedef int (*SQLITE3_EXEC) (sqlite3*, const char*,

RE: [sqlite] Question

Thank you very much. I will check this out and let you know or attach the file(s). Bill -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 12:03 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Question Bill Giannotti wrote: >I have never

[sqlite] SQLite & Palm!

Just got news about SQLite being available on the next generation of PalmOS systems (which is Linux based). This is fantastic news from the perspective of somebody looking to start Palm development. The concept of a Palm device that I can ssh to is also somewhat amusing. So has ACCESS or

Re: [sqlite] sqlite3 dll symbols

Essien Essien wrote: > hiya, > > I have a code snippet that looks like: > > typedef int (*SQLITE3_CLOSE)(sqlite3*); > typedef const char* (*SQLITE3_ERRMSG)(sqlite3*); > typedef int (*SQLITE3_OPEN)(const char*, sqlite3**); > typedef int (*SQLITE3_EXEC) (sqlite3*, const char*, sqlite3_callback,

Re: [sqlite] Question

Bill Giannotti wrote: I have never installed the sqlite database, do not know how it got initiated on my computer or how it got invoked by my computer or programs, but I am getting lots of files filling up my temp directory of the form "sqlite_gibberish" with no extension, as well as files of

Re: [sqlite] Question

Bill Giannotti wrote: I have never installed the sqlite database, do not know how it got initiated on my computer or how it got invoked by my computer or programs, but I am getting lots of files filling up my temp directory of the form "sqlite_gibberish" with no extension, as well as files of

[sqlite] Question

I have never installed the sqlite database, do not know how it got initiated on my computer or how it got invoked by my computer or programs, but I am getting lots of files filling up my temp directory of the form "sqlite_gibberish" with no extension, as well as files of the form "ver1a.tmp,

RE: [sqlite] Re: Question regarding schema change error

> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Friday, March 31, 2006 12:14 PM > To: SQLite > Subject: [sqlite] Re: Question regarding schema change error > ... > > > The thing is, in 99.9% > > of the time, the error would be received on the first call

Re: [sqlite] Re: sqlite3 dll symbols

On 3/31/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > Essien Essien <[EMAIL PROTECTED]> wrote: > > _sqlite3_open = (SQLITE3_OPEN)GetProcAddress(sqlite3_dll, > > "sqlite3_open"); > > if (_sqlite3_open == NULL) { > > printf("Cannot load function sqlite3_open"); > > return

[sqlite] Re: sqlite3 dll symbols

Essien Essien <[EMAIL PROTECTED]> wrote: _sqlite3_open = (SQLITE3_OPEN)GetProcAddress(sqlite3_dll, "sqlite3_open"); if (_sqlite3_open == NULL) { printf("Cannot load function sqlite3_open"); return 0; } } I'm using Turbo C++ 4.5 IDE and related tools. (yeah... i know

[sqlite] sqlite3 dll symbols

hiya, I have a code snippet that looks like: typedef int (*SQLITE3_CLOSE)(sqlite3*); typedef const char* (*SQLITE3_ERRMSG)(sqlite3*); typedef int (*SQLITE3_OPEN)(const char*, sqlite3**); typedef int (*SQLITE3_EXEC) (sqlite3*, const char*, sqlite3_callback, void*, char**); HINSTANCE sqlite3_dll;

[sqlite] Re: Question regarding schema change error

Andrew Shakinovsky wrote: I have a database which needs to be accessed by multiple users/processes. During it's lifetime it will have tables added to it periodically through a CREATE TABLE statement. The problem I am running into is that when the sqlite3_step function is called, I receive a

Re: [sqlite] SQLITE_BUSY [5] database is locked

I tried it. Apparently the error gets thrown by the stmt.execDML() statement. It never makes it to any code past the execDML. Paul - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Friday, March 31, 2006 10:49 AM Subject: Re: [sqlite]

[sqlite] Question regarding schema change error

I am having a minor issue with schema changes and am looking for the best solution/workaround. I am using the latest released version of Sqlite, by the way. I have a database which needs to be accessed by multiple users/processes. During it's lifetime it will have tables added to it periodically

Re: [sqlite] SQLITE_BUSY [5] database is locked

On 3/31/06, Paul Pigott <[EMAIL PROTECTED]> wrote: > Greetings all, Greetings :) > The C_DAOService class works fine. It gives me no problems. But when I try > to insert a row with the C_DAOPerformer class, I'm getting an "SQLITE_BUSY > [5] database is locked" error. And I don't know why.

Re: [sqlite] improving query performance

On 3/30/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > > > Another approach is to remove your primary key. If you don't need it to > enforce uniqueness constraints on your data then you could eliminate the > primary key, and change the EntryId column into an integer primary key > column. This

[sqlite] SQLITE_BUSY [5] database is locked

Greetings all, I imagine this has been covered before, but I've been through the archives and couldn't find what I needed. So I'm appealing to a larger authority. I am writing some C++ objects to handle access to a database. Two of them are virtually identical: C_DAOService and

Re: [sqlite] Creating tables with open statements

> The SQLITE_SCHEMA case is handled in our code. But in this case, we are > in the middle of iterating a statement. Can we prepare it again without > "losing our place"? Is this the right action considering that we are > getting a SQLITE_ERROR when executing the statement, not SQLITE_SCHEMA? I'm

Re: [sqlite] quote() and constraints

On 3/29/06, Pam Greene <[EMAIL PROTECTED]> wrote: > On 3/29/06, jt <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I'm implementing a log procedure with triggers on my tables (following > > some ideas found in http://www.sqlite.org/cvstrac/wiki?p=UndoRedo). > > As I have more than one table, I'm

Re: [sqlite] Creating tables with open statements

Jay Sprenkle wrote: On 3/31/06, Matthew Gertner <[EMAIL PROTECTED]> wrote: Hi, I'm trying to detect changes in our application schema and update the corresponding database schema automatically, but only when the table in question is actually needed (i.e. a sort of on-demand schema update).

Re: [sqlite] Creating tables with open statements

On 3/31/06, Matthew Gertner <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to detect changes in our application schema and update the > corresponding database schema automatically, but only when the table in > question is actually needed (i.e. a sort of on-demand schema update). > The problem I'm

[sqlite] Creating tables with open statements

Hi, I'm trying to detect changes in our application schema and update the corresponding database schema automatically, but only when the table in question is actually needed (i.e. a sort of on-demand schema update). The problem I'm having is when other statements are open when this occurs,

Re: [sqlite] Performance Difference on Linux Kernel 2.4 and Kernel 2.6

Phuah Yee Keat <[EMAIL PROTECTED]> wrote: > Hi, > > I would like to take a shot at asking this question here instead of > Linux kernel mailing list just in case anyone here have encountered this > issue before. > > I am running sqlite 3.3.4. > > On a desktop slackware 10.2 machine, I have

[sqlite] Performance Difference on Linux Kernel 2.4 and Kernel 2.6

Hi, I would like to take a shot at asking this question here instead of Linux kernel mailing list just in case anyone here have encountered this issue before. I am running sqlite 3.3.4. On a desktop slackware 10.2 machine, I have installed two stock kernels 2.4.31 and 2.6.13. The box is using