[sqlite] Error help

>> 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: > > > >

[sqlite] Error help

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:

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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

[sqlite] Error help

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. > >

[sqlite] Error help

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