Re: [sqlite] building 3.4.1

2007-08-01 Thread Joe Wilson
Can you post the output for the failed tests? i.e.: footest-13.1... Expected: [10] Got: [0] --- Victor Secarin <[EMAIL PROTECTED]> wrote: > Hello, everyone. I just started to look at the software and I have two > questions: > > Question 1: > > > > Building sqlite-3.4.1, as

Re: [sqlite] How to set up sqlite3 with Dev C++

2007-08-01 Thread John Stanton
Sqlite3.h is not the source, it is the header file to be used by ypur application. Stephen Sutherland wrote: never mind. It seems I have it. It seems I had to include the source - the sqlite3.h file Stephen Sutherland <[EMAIL PROTECTED]> wrote: by dynamic link library. i'm

Re: [sqlite] How to set up sqlite3 with Dev C++

2007-08-01 Thread John Stanton
Stephen Sutherland wrote: never mind. It seems I have it. It seems I had to include the source - the sqlite3.h file Stephen Sutherland <[EMAIL PROTECTED]> wrote: by dynamic link library. i'm gusiness you are talking about the sqlite3.dll. What is hte procedure to link it ? it

Re: [sqlite] How to set up sqlite3 with Dev C++

2007-08-01 Thread John Stanton
If you are using the Sqlite API you need sqlite3.h. Put it in your regular "include" directory and Dev C++ will find it. Stephen Sutherland wrote: by dynamic link library. i'm gusiness you are talking about the sqlite3.dll. What is hte procedure to link it ? it seems to me that as

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

2007-08-01 Thread Joe Wilson
Maybe the php wrapper is not closing sqlite connections correctly (or at all). See if you can get the stack traces of all threads in the php process 162 via pstack, lsstack or by attaching gdb to it at runtime. > COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME > php

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

2007-08-01 Thread Zbigniew Baniewski
On Thu, Jul 26, 2007 at 04:26:41PM -0700, [EMAIL PROTECTED] wrote: > If it works and then later stops working, it's much more likely that > you're having a problem with some file descriptor that is not closed > properly (on the temp db most likely). > If it dies after let's say a week, you can

[sqlite] building 3.4.1

2007-08-01 Thread Victor Secarin
Hello, everyone. I just started to look at the software and I have two questions: Question 1: Building sqlite-3.4.1, as obtained from the cvs, on Fedora 5, 64 bits, with gcc 4.1.1, over glibc-2.4-11, and tcl/tcl-devel 8.4.13-1.1, followed by "make fulltest", I get the following three

[sqlite] Query Help

2007-08-01 Thread Aviad Harell
Hi, I Have a problem with the following query executed on sqlite SELECT CUSTOMER, PRODUCT, [RANK] FROM (SELECT CUSTOMER, PRODUCT, [SUM_SALES], (SELECT COUNT(T2.SUM_SALES) FROM (SELECT CUSTOMER,

[sqlite] Re: autoincrement and fts2?

2007-08-01 Thread Adam Megacz
>> > In fts tables all columns other than rowid are of type TEXT. It >> > doesn't matter what you put in the type, they will be of type TEXT. >> > The rowid is the standard SQLite rowid, so it does provide an INTEGER >> > PRIMARY KEY AUTOINCREMENT column. >> Scott, thanks for your reply.

[sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-01 Thread Paul Harris
Hi, I wanted to get a LOG10() function in sqlite3, and I found the extension-functions.tgz file in http://sqlite.org/contrib I am using the all-in-one sqlite3.h/c version of sqlite3, and the extension-functions files don't seem to fit at all. For example, it wants to call a function called

Re: [sqlite] In-Memory Database: Delete rows on a Table increases the memory usage.

2007-08-01 Thread Christian Smith
Lokesh Babu uttered: Hello Folks, When I perform the DELETE operation on a Table using In-Memory Database (":memory:"), the memory usage increases. I tried using PRAGMA auto_vacuum=1; /* result - nothing works */ Even I tried using VACUUM table_name; /* this too isn't work */ if I perform

[sqlite] Re: How to use step function in bidirection (Next and Previous) ?

2007-08-01 Thread Igor Tandetnik
Hai Handsome <[EMAIL PROTECTED]> wrote: How to use step function in bidirection (Next and Previous) ? I write the database application that use SQLite v3.4.1 and I place two buttons "Next" and "Previous" for go forward and go backward of row. I found SQLite has only "sqlite3_step(stmt)"

[sqlite] How to use step function in bidirection (Next and Previous) ?

2007-08-01 Thread Hai Handsome
How to use step function in bidirection (Next and Previous) ? I write the database application that use SQLite v3.4.1 and I place two buttons "Next" and "Previous" for go forward and go backward of row. I found SQLite has only "sqlite3_step(stmt)" function that can do only go forward in "Next"