• Welcome, Guest. Please login.
 
May 26, 2019, 12:41:02 pm

News:

Welcome to the SQLitening support forums!


Error handling in Sqlite3

Started by Asha M.R, January 22, 2013, 01:15:55 am

Previous topic - Next topic

Asha M.R

Hi,

I want an error to be ignored when importing CSV file to sqlite table.
In specific, if there is mismatch in number of columns in csv file and the table created.

I am running the .bat file in windows which executes a .sqlite file containing the .import command in it.
Please provide the solution for this since am blocked.

Thanks,
Asha

Bern Ertl

Maybe one of the pragma functions can help (ignore check constraints?):

http://www.sqlite.org/pragma.html