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
1,yes,13
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
--
Ri
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
> -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 someone
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 [
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 upda
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 SQLITE_DONE
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
simple
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 as
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 (a
> -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
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 w
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 empt
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
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]
Sen
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> sqlit
> -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 followin
>>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 return
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 probl
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 col2
>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
[snip]
> if (sqlite3_prepare(db, "SELECT * FROM tbookings", -1, &rs,
> &psz) ==
> SQLITE_OK)
> {
> rc = SQLITE_ROW;
> while (rc == SQLITE_ROW)
>{
>
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 wit
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
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 memor
Hi List,
Let us assume there are 10 results for a Query. If I want to abort the
Query after 5 results How can I do that? What notification I will get once I
got all the results and of if there are any errors after 6th result.
How to specify a primary Key, foreign key while creating a table.
Th
Why don't you use mingw + msys enviroment?
Google for more.
Regards,
Miha
"Yuvaraj Athur Raghuvir" <[EMAIL PROTECTED]> je ob 3.10.2006 3:19:21 napisal(a):
>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
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 memor
Hi List,
Let us assume there are 10 results for a Query. If I want to abort the
Query after 5 results How can I do that? What notification I will get once
I
got all the results and of if there are any errors after 6th result.
How to specify a primary Key, foreign key while creating a table.
Hi All,
I have downloaded the SQLite library (sqlite-3.3.7.so.gz) from the
homepage. But I don't know how to install it. Please help me. My Redhat
Enterprise Linux machine runs on i386 architecture.
Thanks and Regards,
Lloyd.
__
Scanned and protected by
30 matches
Mail list logo