Hi List,
we have ported SQLite to one of our consumer products. We require some
minimal applications only like creating and deleting table and Inserting ,
Querying, deleting rows in a table. So, We are planning to remove some of
the features like create view and etc , as we are facing some
Hello,
I have sync'ed and created the exe using Cygwin on Windows. I also have the
libtool available.
Now, I donot see the dll that I can use in Windows environment.
How to create a dll?
Regards,
Yuva
Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>
> I understand, I to did not understand what happened.
> But the code below shows my point (sorry for the horrible indentation).
Rather than apologize, why not just fix it? Is your time so
much more valuable than ours that you cannot be troubled
[snip]
> if (sqlite3_prepare(db, "SELECT * FROM tbookings", -1, ,
> ) ==
> SQLITE_OK)
> {
> rc = SQLITE_ROW;
> while (rc == SQLITE_ROW)
>{
>
>From: Igor Tandetnik <[EMAIL PROTECTED]>
>Subject: Re: Where to look in the code for this ?
>Newsgroups: gmane.comp.db.sqlite.general
>Date: 2006-10-02 21:53:13 GMT (1 hour and 1 minute ago)
>Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>>> Surely you mean "until the process completes its write
Thank you for the suggestions. I had no idea this would get such a response.
Sqlite Administrator recognized my null values as zero, so that
doesn't seem to be an option. For an immediate solution, it sounds
like I need to do as Dennis suggested:
.import test1.csv test1
update test1 set
Martin Alfredsson <[EMAIL PROTECTED]> wrote:
Surely you mean "until the process completes its write operation".
I wish, but no, the database is locked until the process that writes
is terminated.
I find it hard to believe. Concurrent reads and writes work in my
experience. I'd look for
>>Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>> My problem is that the SHARED lock does not stay after
>>_step() returns
>> SQLITE_DONE and that this allows another process to update the
>> database and I end up with a locked database.
>Why exactly is this a bad thing? When sqlite3_step
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 02, 2006 1:44 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] import syntax and null values
>
>
> Fred Williams wrote:
> >
> >
> > Don't mean to split hairs, but...
> >
> > For the
Hello Voxen,
Monday, October 2, 2006, 2:13:39 PM, you wrote:
V> Greetings,
V> I have a deadlock on my application when I use multiple threads.
V> I use 3 thread classes, let call them ThreadA, ThreadB, ThreadC.
V> ThreadA opens a sqlite connection, then creates a ThreadB which opens a
V>
You could try:
www.sqliteexpert.com
Data transfer wizard -> Import from ADO data source -> Microsoft OLE DB
provider for ODBC drivers -> dBase files
should do the job, though I never tried with DBF databases.
Bogdan
-Original Message-
From: Graham Wickens [mailto:[EMAIL PROTECTED]
Hi All,
I am a newcomer to SQLite and would like to know the best way to get
data from my DBF4 database to a SQLite SQb. I need to do this because
SQLite is used by a USB Device I recently purchased. I am at hobby level
for DBF4 but have no exposure to SQLite before.
TIA
Sorry if this is a
Fred Williams wrote:
Don't mean to split hairs, but...
For the following, the "," is the field delimiter and '"' is the string
delimiter.
Although this may fly in the face of reality, an empty string should be
denoted with ,"", and a null value by ,,. Who is to say whether ,,
denotes an
Fred Williams wrote:
> Would it not be more logical to modify the .import command to place a
> null value in a column where the input value is non existent? (i.e. Back
> to back separators in the input) Null in, null out.
Please don't do that. I have many databases with empty strings in them
> -Original Message-
> From: Gerry Snyder [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 02, 2006 12:42 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] import syntax and null values
>
>
> Fred Williams wrote:
> > Would it not be more logical to modify the .import command
> to
Greetings,
I have a deadlock on my application when I use multiple threads.
I use 3 thread classes, let call them ThreadA, ThreadB, ThreadC.
ThreadA opens a sqlite connection, then creates a ThreadB which opens a
sqlite connection then creates a ThreadC which also opens a sqlite
connection
Fred Williams wrote:
Would it not be more logical to modify the .import command to place a
null value in a column where the input value is non existent? (i.e. Back
to back separators in the input) Null in, null out.
Fred,
If you did that, there would be no way to enter an empty string
Fred Williams wrote:
Would it not be more logical to modify the .import command to place a
null value in a column where the input value is non existent? (i.e. Back
to back separators in the input) Null in, null out.
A null is not the same thing as an empty string. Some things would be
Martin Alfredsson <[EMAIL PROTECTED]> wrote:
My problem is that the SHARED lock does not stay after _step() returns
SQLITE_DONE and that this allows another process to update the
database and I end up with a locked database.
Why exactly is this a bad thing? When sqlite3_step returns
Anyone familiar with SQLite source ?
Opened a tecked a few days ago (#1995). However I did not check enough
and found out I only got the error in a subset of the tests;
My problem is that the SHARED lock does not stay after _step() returns
SQLITE_DONE and that this allows another process to
http://www.sqlite.org/cvstrac/tktnew
gives;
Query failed
Database query failed:
SELECT name, value FROM enums WHERE type='type'
Reason: database disk image is malformed
/Martin
-
To unsubscribe, send email to
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 02, 2006 9:26 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] import syntax and null values
>
>
> Rich Shepard wrote:
> > On Mon, 2 Oct 2006, Eric Matthew Finnin wrote:
> >
> >> Could
Rich Shepard wrote:
On Mon, 2 Oct 2006, Eric Matthew Finnin wrote:
Could someone tell me the syntax for the .import command? I can't
seem to
get my null values to be recognized.
.nullvalue STRING Print STRING in place of NULL values
If you type '.h' you'll see the syntax of all the
On Mon, 2 Oct 2006, Eric Matthew Finnin wrote:
Could someone tell me the syntax for the .import command? I can't seem to
get my null values to be recognized.
.nullvalue STRING Print STRING in place of NULL values
If you type '.h' you'll see the syntax of all the commands.
Rich
--
Could someone tell me the syntax for the .import command? I can't
seem to get my null values to be recognized.
First I created test1:
CREATE TABLE [test1] (
[col1] INTEGER NOT NULL,
[col2] TEXT NULL,
[col3] INTEGER NULL
)
The data for test1.csv has the following data:
col1,col2,col3
25 matches
Mail list logo