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 >
