Re: [sqlite] Question about trigger

Sure I can provide the schema: create table AICC_objectives_status ( session_id nvarchar(12)not null, j_id varchar(255)null, j_status nvarchar(13)null, j_score

[sqlite] Remote access to sqlite databases

Hi, I'm writing a server that will give remote access to sqlite databases. I plan to give a C library that will offer the same APIs as sqlite but will access the database through the server. I will write a MFC GUI application to run sql commands and reports on remote sqlite servers. This will

Re: [sqlite] Error compiling example

On Wed, 29 Sep 2004, Max wrote: You need to link against the SQLite library: $ gcc pippo.c -o pippo -lsqlite Nothing the result is the same .. you need to link against the sqlite version 3 library (you've probably succesfully linked against a version 2 library on your system). try something like

Re: [sqlite] Error compiling example

> > You need to link against the SQLite library: > > $ gcc pippo.c -o pippo -lsqlite > > Nothing the result is the same .. Your library is probably named sqlite3.so or sqlite-3.0.7.so or something like that. You have to give gcc the right name. Also, you have to put the library is a directory

Re: [sqlite] Error compiling example

> You need to link against the SQLite library: > $ gcc pippo.c -o pippo -lsqlite Nothing the result is the same .. Ciao Max -- Secondo alcuni autorevoli testi di tecnica Aeronautica, il calabrone non può volare, a causa della forma e del peso del proprio corpo in rapporto alla superficie alare.

Re: [sqlite] Error compiling example

On Wed, 29 Sep 2004, Max wrote: >I'm trying to compile this little example from www.sqlite.org > [snip] > >I compile this program : gcc pippo.c -o pippo > >But the result is : > >/tmp/ccH7jM5Y.o: In function `main': >/tmp/ccH7jM5Y.o(.text+0xd5): undefined reference to `sqlite3_open'

Re: [sqlite] Ruby - SQLite 3.0.7

On Wed, 29 Sep 2004, Federico Granata wrote: Hi I'm looking for a sqlite 3.0.7 wrapper for ruby (nothin found with wiki). sqlite 2.x series is at http://sqlite-ruby.rubyforge.org/ i think 3.x is in the work by jamis buck, if not i'll proably attack in a month or so. -a --

Re: [sqlite] Question about trigger

Without the schema, it's difficult to say where the problem is. Check spelling and make sure session_id is a column in AICC_core. Christian PS. If you're sure AICC_core has session_id, but don't want to publish your schema for any reason, try reproducing the problem with an example

[sqlite] Error compiling example

I'm trying to compile this little example from www.sqlite.org #include #include #include #include "sqlite3.h" static int callback(void *NotUsed, int argc, char **argv, char **azColName) { int i; for( i = 0; i < argc; i++) { printf("%s = %s\n", azColName[i], argv[i] ? argv[i] :

Re: [sqlite] Re: FOREIGN:[sqlite] Receiving notification of table updates

On Wed, 29 Sep 2004, Kazuho Oku wrote: >From: "Christian Smith" <[EMAIL PROTECTED]> >> On Tue, 28 Sep 2004, Kazuho Oku wrote: > >> >Unfortunately, my apache module only performs a single SELECT clause of >> >which WHERE clause can be indexed. >> >What I am wondering is the way to stop calling

RE: [sqlite] Is there...?

http://sqlitebrowser.sourceforge.net/ Edgardo Rossetto wrote: > Anything like a visual manager for sqlite dbs? > > or just the command line tool? > > Regards, > Edgardo reid

Re: [sqlite] Pre-compiling statements

Arno Engelbrecht wrote: > Does anybody know how to pre-compile a statement? Basically I want to do > mulitple inserts into the same table and want to cut down on the time to > parse each statement. > > http://www.sqlite.org/capi3ref.html#sqlite3_prepare -- D. Richard Hipp -- [EMAIL PROTECTED] --

Re: [sqlite] Sqlite3 BLOB support

On 29 Sep 2004, at 11:23, Serge Semashko wrote: Hello all, I'm sorry for a probably lame question, I'm new to sqlite and database programming. Is it possible to store very large files in sqlite3 database? Are there any limitations? http://www.sqlite.org/faq.html#q10 Matt.

[sqlite] Sqlite3 BLOB support

Hello all, I'm sorry for a probably lame question, I'm new to sqlite and database programming. Is it possible to store very large files in sqlite3 database? Are there any limitations?

[sqlite] Ruby - SQLite 3.0.7

Hi I'm looking for a sqlite 3.0.7 wrapper for ruby (nothin found with wiki). Can you help me ? -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Biscotti perfetti? Metti la pasta dentro allo Sparabiscotti e...click click... biscotti pronti per

[sqlite] Pre-compiling statements

Does anybody know how to pre-compile a statement? Basically I want to do mulitple inserts into the same table and want to cut down on the time to parse each statement.