[sqlite] Error help

[William Drago]

>>   I was taught the basics in SQLite with Firefox, and
>> am already disappointed that I can't really do what I want to do with the
>> Firefox plug in.
> Plenty of other ways to use SQLite with a graphical GUI:
>
> 
> 
> 
>
> Simon.

Don't forget about SQLite Expert. It's one of the best free 
admin tools I've used.

http://www.sqliteexpert.com/

-Bill

[sqlite] Error help

[Simon Slavin]

On 4 Apr 2016, at 7:31pm, Daniel Telvock  
wrote:

>  I was taught the basics in SQLite with Firefox, and
> am already disappointed that I can't really do what I want to do with the
> Firefox plug in.

Plenty of other ways to use SQLite with a graphical GUI:





Simon.

[sqlite] Error help

[Simon Slavin]

On 4 Apr 2016, at 7:22pm, Daniel Telvock  
wrote:

> Even when trained to use SQLite I was told it could handle large CSV files,
> and this one was only 1000 rows

SQLite handles it fine.  I have a 39 Gigabyte database using SQLite.

The thing you're using is not SQLite.  It's a program which does a lot of 
things, using SQLite but also lots of code written by people who have nothing 
to do with SQLite.  The error you reported is not an SQLite error.  The 'NS' at 
the beginning of the error name is a hang over from back when Mozilla was 
called 'NetScape'.

Simon.

[sqlite] Error help

[Simon Slavin]

On 4 Apr 2016, at 6:17pm, Richard Hipp  wrote:

> It is.  Don't confuse SQLite with the Firefox plugin for SQLite.  The
> limit you have reached seems to be a limitation with the Firefox
> plugin, not with SQLite itself.

I confirm that the NS_ERROR_STORAGE_CONSTRAINT error is generated by the 
Mozilla codebase (i.e. Netscape).  If you would like to download the SQLite 
shell tool and try the import using that, you'll probably have no trouble 
importing your data.



 Precompiled Binaries

Simon.

[sqlite] Error help

[Simon Slavin]

On 4 Apr 2016, at 5:04pm, Daniel Telvock  
wrote:

> When you have a columns that has lengthy text, is there a way to label it
> so SQLite won't spit it out as an error?

There is no problem with storing lengthy text in a SQLite field.  It makes no 
difference how you label the column since everything gets converted to TEXT 
anyway.  Whatever your problem is it's not related to labelling.

Please state your platform and development environment.

Simon.

[sqlite] Error help

[Daniel Telvock]

Understood, thanks.

Clearly, I am a neophyte at this stuff and have not learned how to use SQL
with the command line. I was taught the basics in SQLite with Firefox, and
am already disappointed that I can't really do what I want to do with the
Firefox plug in.

I guess I can try to learn Microsoft Access.

Dan Telvock
Environment Reporter
Investigative Post 
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 to use SQLite I was told it could handle large CSV
> files,
> > and this one was only 1000 rows
>
> SQLite handles it fine.  I have a 39 Gigabyte database using SQLite.
>
> The thing you're using is not SQLite.  It's a program which does a lot of
> things, using SQLite but also lots of code written by people who have
> nothing to do with SQLite.  The error you reported is not an SQLite error.
> The 'NS' at the beginning of the error name is a hang over from back when
> Mozilla was called 'NetScape'.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Daniel Telvock]

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 
Twitter: @dantelvock
716-831-2626 ext. 3


On Mon, Apr 4, 2016 at 2:21 PM, Richard Hipp  wrote:

> On 4/4/16, Simon Slavin  wrote:
> >
> > On 4 Apr 2016, at 6:17pm, Richard Hipp  wrote:
> >
> >> It is.  Don't confuse SQLite with the Firefox plugin for SQLite.  The
> >> limit you have reached seems to be a limitation with the Firefox
> >> plugin, not with SQLite itself.
> >
> > I confirm that the NS_ERROR_STORAGE_CONSTRAINT error is generated by the
> > Mozilla codebase (i.e. Netscape).  If you would like to download the
> SQLite
> > shell tool and try the import using that, you'll probably have no trouble
> > importing your data.
> >
>
> And once you get the data imported, probably the Firefox plugin will
> work fine for querying and general maintenance.
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Richard Hipp]

On 4/4/16, Simon Slavin  wrote:
>
> On 4 Apr 2016, at 6:17pm, Richard Hipp  wrote:
>
>> It is.  Don't confuse SQLite with the Firefox plugin for SQLite.  The
>> limit you have reached seems to be a limitation with the Firefox
>> plugin, not with SQLite itself.
>
> I confirm that the NS_ERROR_STORAGE_CONSTRAINT error is generated by the
> Mozilla codebase (i.e. Netscape).  If you would like to download the SQLite
> shell tool and try the import using that, you'll probably have no trouble
> importing your data.
>

And once you get the data imported, probably the Firefox plugin will
work fine for querying and general maintenance.

-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] Error help

[Richard Hipp]

On 4/4/16, Daniel Telvock  wrote:
> Not sure of size. But I had thought one of benefits of using SQLite was
> ability to import larger CSV files or worksheets that slow down in Excel

It is.  Don't confuse SQLite with the Firefox plugin for SQLite.  The
limit you have reached seems to be a limitation with the Firefox
plugin, not with SQLite itself.

-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] Error help

[Daniel Telvock]

Not sure of size. But I had thought one of benefits of using SQLite was
ability to import larger CSV files or worksheets that slow down in Excel



Dan Telvock
Environment Reporter
Investigative Post 
Twitter: @dantelvock
716-831-2626 ext. 3


On Mon, Apr 4, 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 <
> dtelvock at investigativepost.org> wrote:
>
> > I am using the Firefox plugin of SQLite and this is a large CSV file
> that I
> > am importing in the wizard. When I try to import, I get that error
> >
> > CHECK constraint failed: REDCs_refined ]
> > Exception Name: NS_ERROR_STORAGE_CONSTRAINT
> > Exception Message: Component returned failure code: 0x80630003
> > (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]
> >
> > Dan Telvock
> > Environment Reporter
> > Investigative Post 
> > 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 Telvock <
> dtelvock at investigativepost.org
> > >
> > > wrote:
> > >
> > > > When you have a columns that has lengthy text, is there a way to
> label
> > it
> > > > so SQLite won't spit it out as an error?
> > >
> > > There is no problem with storing lengthy text in a SQLite field.  It
> > makes
> > > no difference how you label the column since everything gets converted
> to
> > > TEXT anyway.  Whatever your problem is it's not related to labelling.
> > >
> > > Please state your platform and development environment.
> > >
> > > Simon.
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users at mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Stephen Chrzanowski]

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 <
dtelvock at investigativepost.org> wrote:

> I am using the Firefox plugin of SQLite and this is a large CSV file that I
> am importing in the wizard. When I try to import, I get that error
>
> CHECK constraint failed: REDCs_refined ]
> Exception Name: NS_ERROR_STORAGE_CONSTRAINT
> Exception Message: Component returned failure code: 0x80630003
> (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]
>
> Dan Telvock
> Environment Reporter
> Investigative Post 
> 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 Telvock  >
> > wrote:
> >
> > > When you have a columns that has lengthy text, is there a way to label
> it
> > > so SQLite won't spit it out as an error?
> >
> > There is no problem with storing lengthy text in a SQLite field.  It
> makes
> > no difference how you label the column since everything gets converted to
> > TEXT anyway.  Whatever your problem is it's not related to labelling.
> >
> > Please state your platform and development environment.
> >
> > Simon.
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Daniel Telvock]

I am using the Firefox plugin of SQLite and this is a large CSV file that I
am importing in the wizard. When I try to import, I get that error

CHECK constraint failed: REDCs_refined ]
Exception Name: NS_ERROR_STORAGE_CONSTRAINT
Exception Message: Component returned failure code: 0x80630003
(NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]

Dan Telvock
Environment Reporter
Investigative Post 
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 Telvock 
> wrote:
>
> > When you have a columns that has lengthy text, is there a way to label it
> > so SQLite won't spit it out as an error?
>
> There is no problem with storing lengthy text in a SQLite field.  It makes
> no difference how you label the column since everything gets converted to
> TEXT anyway.  Whatever your problem is it's not related to labelling.
>
> Please state your platform and development environment.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Richard Hipp]

On 4/4/16, Daniel Telvock  wrote:
> There is a field that contains longer sentences for descriptions. It keeps
> giving me an error that the NS Error Storage Constraint.

Can you please provide more context about what you are trying to do?
I do not understand the description of your problem.


>
> 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 out as an error?
>
>  CHECK constraint failed: REDCs_refined ]
> Exception Name: NS_ERROR_STORAGE_CONSTRAINT
> Exception Message: Component returned failure code: 0x80630003
> (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]
>
>
> Dan Telvock
> Environment Reporter
> Investigative Post 
> Twitter: @dantelvock
> 716-831-2626 ext. 3
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] Error help

[Daniel Telvock]

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 out as an error?

 CHECK constraint failed: REDCs_refined ]
Exception Name: NS_ERROR_STORAGE_CONSTRAINT
Exception Message: Component returned failure code: 0x80630003
(NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]


Dan Telvock
Environment Reporter
Investigative Post 
Twitter: @dantelvock
716-831-2626 ext. 3