Microsoft Access.
Dan Telvock
Environment Reporter
Investigative Post <http://www.investigativepost.org/>
Twitter: @dantelvock
716-831-2626 ext. 3
On Mon, Apr 4, 2016 at 2:27 PM, Simon Slavin wrote:
>
> On 4 Apr 2016, at 7:22pm, Daniel Telvock
> wrote:
>
> > Even when trained
Using the non plugin option is a little above my head. I haven't been
trained to use the command line.
Even when trained to use SQLite I was told it could handle large CSV files,
and this one was only 1000 rows
Dan Telvock
Environment Reporter
Investigative Post
, 2016 at 12:52 PM, Stephen Chrzanowski
wrote:
> Large CSV? How large? Because the constraint error is probably coming
> from the browser for an upload constraint on size versus SQLite throwing an
> error.
>
>
> On Mon, Apr 4, 2016 at 12:26 PM, Daniel Telvock <
> dte
(NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]
Dan Telvock
Environment Reporter
Investigative Post <http://www.investigativepost.org/>
Twitter: @dantelvock
716-831-2626 ext. 3
On Mon, Apr 4, 2016 at 12:21 PM, Simon Slavin wrote:
>
> On 4 Apr 2016, at 5:04pm, Daniel Telv
There is a field that contains longer sentences for descriptions. It keeps
giving me an error that the NS Error Storage Constraint.
I've tried labeling the column as VarCHar and Text to not avail.
When you have a columns that has lengthy text, is there a way to label it
so SQLite won't spit it
Anyone know what this is trying to tell me? I cannot import the CSV because
of this error.
Everything is labeled as VARCHAR and api_well_number is marked as the
unique identifier.
SQLiteManager: INSERT INTO "main"."WELLS" VALUES ("Adams, E.H. et
al",'Schuyler','Hector','3.11E+13','Collins
I was at the Investigative Reporters and Editors Conference last week and
the presenter for SQLite courses 1 and 3 said that it is actually
pronounced SQ Lite. Even he thought that was odd considering SQL is a term
or acronym.
Dan Telvock
Environment Reporter
Investigative Post
7 matches
Mail list logo