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
> -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
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
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
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
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.
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
23 matches
Mail list logo