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 <http://www.investigativepost.org/> Twitter: @dantelvock 716-831-2626 ext. 3 On Mon, Apr 4, 2016 at 12:52 PM, Stephen Chrzanowski <pontiac76 at gmail.com> 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 <http://www.investigativepost.org/> > > Twitter: @dantelvock > > 716-831-2626 ext. 3 > > > > > > On Mon, Apr 4, 2016 at 12:21 PM, Simon Slavin <slavins at bigfraud.org> > > 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 >
