Hi Dennis,
Thank you for your reply :)
I'm using SQLite in .NET through Finisar.SQLite wrapper.
The locking mechanism is a static object which I use as a mutex by the
.NET 'lock'-method.
And finally - yes, I open and close the database in each transaction:
Regarding the API that returns the err
Hi,
I am using Sqlite with Java and driver I am using is
javsqlite(http://www.ch-werner.de/javasqlite/). I want to have multiple
threads reading data simultaneously from SQLite (as Sqlite claims to be
Threadsafe) it seems to be possible. But going through java driver code,
all methods which talk t
My SQL Statement is a standard null terminated C string (UTF-8
format). The termination is at the proper place. strlen() verifies
this.
Is the string supposed to be something else than a C string?
What is really odd is that it works perfectly with the installed
3.1.3. With the
Thank you so much cote, for ur valuable suggestion. I would be greatly
thankful to u if u could send me a simple c program which uses the above
API's to insert some values into the SQLite database.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 8
this should work.
UPDATE T1
SET T1.colA = (select T2.colA from T2 where T1.colC = T2.colC),
T1.colB = (select T2.colB from T2 where T1.colC = T2.colC)
WHERE EXISTS (select * from T2 where T1.colC = T2.colC);
Unit 5 wrote:
Hello,
I am trying to update values of some columns in a
table wit
It looks very much as if your SQL statement is being truncated when you
pass it to sqlite3_prepare. Are all your character arrays adequately sized?
JS
Matthew Veenstra wrote:
Hello,
First of Kudos for a such a great program. SQLite is easy to use,
fast, and portable.
Now to my question.
Hello,
First of Kudos for a such a great program. SQLite is easy to use,
fast, and portable.
Now to my question.
I am building a Mac OS X universal binary framework (think dll or
dylib). I build this with a makefile I did by hand based on the
results of configure and the generic make f
Why don't you use the standard PHP DB abstraction layer which provides a
common interface to all DBMS's and incorporates the current version of
Sqlite, Sqlite3? As I see it the Sqlite2 you are using is in PHP for
historical reasons to support legacy code.
JS
Night Media LTD wrote:
Due to the
I am looking at the code in os_win.c for
sqlite3WinOpenReadWrite() and have a question. The
routine uses the windows API CreateFile() to open the
file. First it checks to see if it can open it
read/write and then if that fails, it tries read-only.
Now, when it tries read/write, it uses
FILE_SHARE
--- Night Media LTD <[EMAIL PROTECTED]> wrote:
> Its incredible that a big language as PHP cannot
> have the lastest version of
> sqlite running with...
Maybe the time has come to ask you why do you need the
latest version of sqlite? Version 2.8 is widely used
and as far as I can see works ok an
Hello,
I am trying to update values of some columns in a
table with fresh data from another table. The two
tables have the same column definitions. Is this
possible? Even better would be if the two tables
could be the same; then I could use table aliases in
the update statement.
Here is what I
Due to the size of the binary, I ve choose to develop my application under
php4 instead of php 5
I ve try to install sqlite3
And the only solution I ve found was a plugin developped http://php-sqlite3
sourceforge.net/
But when trying it, it look bugged, when file are created with :me
Michael B. Hansen wrote:
I use my own global locking-mechanism, so only one
connection can be opened at one time.
Michael,
Is it possible that your "own" locking mechanism is failing? You haven't
said how the locks are implemented, and getting mutual exclusion stuff
right in roll your own
Anish Enos Mathew wrote:
I am using sqlite_exec command for doing a particular
process in the data base. But the problem with sqlite_exec is that the
sqlite engine should parse the select or insert statement and then
produces the result.
Anish,
You should definitely look at the sqlite pre-comp
Use compiled SQL by calling sqlite2_prepare.
If you don't want to use SQL then don't bother using Sqlite, just use an
ISAM index file like Berkeley/CISAM/Btrieve etc.
JS
Anish Enos Mathew wrote:
Well, currently I am doing a mobile project and we are testing the
performance of four databases d
"Anish Enos Mathew" <[EMAIL PROTECTED]> wrote:
> Well, currently I am doing a mobile project and we are testing the
> performance of four databases depending on the time it takes to insert
> or delete or search a particular data from the database. I am using
> sqlite3 database. I am using sqlite_e
i m not sure i ve enough skill for make this
Thanks
---Message original---
De : Kevin Waterson
Date : 05/08/06 02:24:53
A : sqlite-users@sqlite.org
Sujet : Re: [sqlite] How to get the lastest version of SQLITE with PHP ???
This one time, at band camp, Ivan Voras
Hi,
I have this problem - that keeps hunting me.
I use SQLite 3.3.5 - with all queries, updates and inserts in
transactions. I use my own global locking-mechanism, so only one
connection can be opened at one time.
However, I keep getting 'library routine called out of sequence' at
random inte
18 matches
Mail list logo