I have created a directory for the project I am working on, and the
Database and the csv file both reside in that directory.
I right Clicked on start and selected the windows cmd, and as I
understand it at the moment
by typing sqlite3 DXCC then it should be sitting in the directory or
On 25 Aug 2016, at 4:03am, Alan wrote:
> attempt to import a short test Excel table
> of two columns with about 4 records in it, the main one I was trying to
> import had the same trouble
> with, it had over 300 records in it with two columns.
Issue this command:
sqlite3
On Aug 24, 2016 10:25 PM, "Alan" wrote:
>
> forgot to reply to one of the questions.
>
> I am using version 3.13.0.0 and it is 64 bit
>
> I am running Windows 10 Pro
>
> computer is intel I3 3.5Ghz with 8Gb RAM.
>
> As my friend has no problem loading the same csv file with
forgot to reply to one of the questions.
I am using version 3.13.0.0 and it is 64 bit
I am running Windows 10 Pro
computer is intel I3 3.5Ghz with 8Gb RAM.
As my friend has no problem loading the same csv file with his Windows7
computer
I am guessing that it may be to do with running
HI Guys
really appreciate all your replies.What I am doing at present is to
attempt to import a short test Excel table
of two columns with about 4 records in it, the main one I was trying to
import had the same trouble
with, it had over 300 records in it with two columns.
the test one has
Alan,
if you are new to sqlite3 then let me give you a little heads up on
something that tripped me up a couple of times in early days. I am assuming
you are the command line sqlite3 interface which will require you to set
the separator for data imports.
.separator ,
...is likely what you want
Windows requires that you escape the \ in the path, effectively doubling
them up.
Regards.
Brian P Curley
On Aug 24, 2016 8:24 PM, "Simon Slavin" wrote:
> I hope someone else can help.
>
> Does that table already exist in the database file ?
>
> Is the first line of the
I hope someone else can help.
Does that table already exist in the database file ?
Is the first line of the csv file a line of data or a line of column names ?
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Hi Simon,
firstly both the database and the csv files are in ther same folder.
I have gone into Windows cmd
typed sqlite3 DXCC(database)
.mode csv
.separator ,
.import anr.csv DXE(DXCC table)
I have also tried putting in the full path to the csv file and
unfortunately
the same result.
On Aug 17, 2016, at 10:38 PM, Keith Medcalf wrote:
>
> Same code, same compile options, same compiler version
> options -s -O3 -pipe -march=native -mtune=native -falign-functions=16
> -falign-loops=16 -flto
Ah, good, actual science this time instead of apples-to-oranges.
On 24 Aug 2016, at 11:04pm, Alan wrote:
> Firstly I am very new to sqlite, but I have a problem when trying to
>
> import a .csv file into a database, getting "cannot open (file).csv"
>
> I am using Windows10 and wondering if anyone else has had this problem.
The program
Firstly I am very new to sqlite, but I have a problem when trying to
import a .csv file into a database, getting "cannot open (file).csv"
I am using Windows10 and wondering if anyone else has had this problem.
A friend has been able to import exactly the same csv file but he is
using
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
Monday, August 29th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
On 8/24/16, Sergey Shamshyn wrote:
> - *PRAGMA journal_mode=OFF* (when not execute this pragma, all is ok).
With journal_mode=OFF, the database may go corrupt if:
(1) The program is ever terminated (ex: using SIGKILL) while the
database is open.
(2) If a COMMIT
Hi, Sergey,
On Wed, Aug 24, 2016 at 8:55 AM, Sergey Shamshyn
wrote:
> Hi.
> I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I think
> this is a 100% SQLite bug, because:
> - only ONE THREAD of my process is writing periodically to db file
> - onlt
Hi.
I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I
think this is a 100% SQLite bug, because:
- only ONE THREAD of my process is writing periodically to db file
- onlt ONE ANOTHER THREAD of my another process reads from this db file
- version 3.14.1
- PRAGMA
Scott Robison wrote:
>
> I'm sure the responsible party will see this and reply shortly with
> something definitive.
>
This is the right place and the System.Data.SQLite design-time components
are supported here.
That being said, the design-time components for System.Data.SQLite are
supported
On Aug 24, 2016 5:35 AM, "Simon Slavin" wrote:
>
>
> On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ
wrote:
>
> > This is also the list for System.Data.SQLite. System.Data.SQLite
supports design time components for VS2015, so this
On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ
wrote:
> This is also the list for System.Data.SQLite. System.Data.SQLite supports
> design time components for VS2015, so this may be the correct list for
> questions regarding issues with using SQLite
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Stephan Beal
> Sent: Wednesday, August 24, 2016 6:37 AM
> To: SQLite mailing list
> Subject: Re: [sqlite] SQLite in VS2015 Server Explorer
On Tue, Aug 23, 2016 at 4:13 PM, Tyler Merle wrote:
> I believe I’ve uncovered two bugs when using VS2015’s Server Explorer to
> design a SQLite schema.
>
> 1. When adding more than one relationship to a table, the first
> relationship’s “to” table name is used for all new
I believe I’ve uncovered two bugs when using VS2015’s Server Explorer to design
a SQLite schema.
1. When adding more than one relationship to a table, the first relationship’s
“to” table name is used for all new relationships
2. The right-click -> design option for tables doesn’t open the
CPU Core at 100% for entire test, x64 code is ~10% faster than x32 code.
So; IO bound things 32/64 doesn't matter so much; but compute bound,
through data already in memory gets significant improvments because of
addtional general purpose registers and optimal calling conventions for
things of
23 matches
Mail list logo