Re: [sqlite] import a CSV-File

2009-03-07 Thread Hans-Martin
Am Freitag, 6. März 2009 23:33:33 schrieb John Machin: > On 7/03/2009 6:16 AM, Rich Shepard wrote: > > On Fri, 6 Mar 2009, Hans-Martin wrote: > >> It seems that there is no way to get rid of the embedded CR/LF without > >> parse the complete output. > >

Re: [sqlite] import a CSV-File

2009-03-06 Thread Hans-Martin
point is not clear for me now. i found http://www.sqlite.org/c3ref/c_limit_attached.html and see about the run_time using sqlite3_limit(), but how can i pass this using pure SQL? Well, looking at the samples it doesn't seems to be too tricky to use the C++API. Can i expect better performance usi

[sqlite] import a CSV-File

2009-03-06 Thread Hans-Martin Bundeshund
Hello to the List! I started using SQLite (3.6.11) under WindowsXP and get confused using the import-function. The import runs well with most lines, but i get an error when it comes to following cases: Case 1, the ',' between a string: "Text of field1","Text of field2, not for field1"