[sqlite] compiling 3.3.7 with loadable extensions

The new loadable extensions cause a range of errors compiling the plain-source file, sqlite-source-3_3_7. Not a problem for me as I'm omitting them with -DSQLITE_OMIT_LOAD_EXTENSION, but log is below: $ unzip sqlite-source-3_3_7.zip $ mv tclsqlite.c tclsqlite.c.not $ gcc -c *.c 2>log In file

Re: [sqlite] linking C program

Michael Alperovitch wrote: Hi, I am new SQLite user. How I can link the simple C Program with Sqlite static or shared library. I tried to link to libsqlite3.a and it cannot find sqlite3_open(), sqllite3_close(), sqllite3_exec() functions. I got the same result linking with libsqlite3.so

Re: [sqlite] starting with unicode

I suppose this is correct: strSql.Format(_T("SELECT * FROM test")); char szSomething[500]; int nTest = sqlite3_bind_text(pStmt, 1, szSomething, 500, SQLITE_STATIC); if (nTest != SQLITE_OK) { TRACE("sqlite3_bind_text fails!! [%i] [%s]\n", nTest, sqlite3_errmsg(db)); } but can I use the

Re: [sqlite] starting with unicode

John, Cory, thank you very much. I got execute plain statements ok by modifying my earlier posting a bit. I was able to create a table using the prepare statement. Previously I was using sqlite3_exec() to execute my statements and I could pass it a callback function which I could use to fetch

Re: [sqlite] linking C program

Michael Alperovitch wrote: Hi, I am new SQLite user. How I can link the simple C Program with Sqlite static or shared library. I tried to link to libsqlite3.a and it cannot find sqlite3_open(), sqllite3_close(), sqllite3_exec() functions. I got the same result linking with libsqlite3.so

Re: [sqlite] linking C program

I always include the source into my C program (with KDevelop for linux or DEV-CPP for windows). And if you do that you could config better. On 8/14/06, Michael Alperovitch <[EMAIL PROTECTED]> wrote: Hi, I am new SQLite user. How I can link the simple C Program with Sqlite static or shared

[sqlite] linking C program

Hi, I am new SQLite user. How I can link the simple C Program with Sqlite static or shared library. I tried to link to libsqlite3.a and it cannot find sqlite3_open(), sqllite3_close(), sqllite3_exec() functions. I got the same result linking with libsqlite3.so shared library. Thanks for

Re: [sqlite] starting with unicode

Mark Wyszomierski wrote: Hi Cory, Alright I gave it a shot from the docs but I'm not handling the prepare statement correctly. I'm trying the ASCI version first. The prepare statement returns an error. Here is the code snippet I'm trying: strSql.Format("CREATE TABLE test (something TEXT,

RE: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

Hi You're correct, our application doesn't need 64 bit support. I've tried your suggestion. Not only does our test harness using the in memory database now work, but also our integration tests ( reading SQLite database files generated by the PC database browser ). So we're now up and

Re: [sqlite] starting with unicode

Hi Cory, Alright I gave it a shot from the docs but I'm not handling the prepare statement correctly. I'm trying the ASCI version first. The prepare statement returns an error. Here is the code snippet I'm trying: strSql.Format("CREATE TABLE test (something TEXT, something_else TEXT, primary

Re: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

"Barrass, Richard" <[EMAIL PROTECTED]> wrote: > Thanks for the help. > > I took a little while to extract our standard out ( It's multiplexed > with the test harness results at current ). > > Here's the trace:- > > VDBE Execution Trace: > SQL: [PRAGMA vdbe_trace=ON] >0 Expire 1

RE: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

Thanks for the help. I took a little while to extract our standard out ( It's multiplexed with the test harness results at current ). Here's the trace:- VDBE Execution Trace: SQL: [PRAGMA vdbe_trace=ON] 0 Expire 10 1 Halt 00 VDBE Execution Trace: SQL:

Re: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

"Barrass, Richard" <[EMAIL PROTECTED]> wrote: > > The breakpoint was hit twice during execution of this test ( once from > the CREATE TABLE Players query, once from the SELECT * from > sqlite_master query ). > On both occasions, pMem->i appeared to be correctly assigned the value > 2. > The

RE: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

Hello Thanks for responding so quickly. It's taken awhile for me to do these tests, as it took me a little time to double check how the compiler lays out it's 64 bit integers ( I've never quite trusted an emulator's watch window! ). I've simplified my tests to an in memory database with the

Re: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

"Barrass, Richard" <[EMAIL PROTECTED]> wrote: > > mingw-win32 compiler (GCC v3.4.2). Our test application works fine with > our small (~22k) test database. > > However, on our embedded platform (ARM 9) with the following > configuration > > Code-sourcey arm-none-eabi cross compiler (GCC

RE: [sqlite] Problems with sqlite 3.3.6 on ARM embedded platform

Hi all, Further information to the original post below is that: 1) The application is single user, single threaded. 2) I have retested using :memory:, rather than my test database file. For this test, I created a database 'on the fly'. Again, the PC host seems to have no problems, but the ARM

Re: [sqlite] About triggers

Galanos <[EMAIL PROTECTED]> wrote: > > In a table I have 2 triggers (BEFORE INSERT). How do I know in which order > they are executed (which is first which is second)? > You don't. The order of arbitrary. -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] About triggers

Hello, In a table I have 2 triggers (BEFORE INSERT). How do I know in which order they are executed (which is first which is second)? Thank you Kostas - To unsubscribe, send email to [EMAIL PROTECTED]