RE: [sqlite] A Data Importation Question

2007-07-31 Thread Lee Crain
es one record at a time and INSERT each record into our database. Best regards, Lee Crain __ -Original Message- From: Griggs, Donald [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 31, 2007 3:35 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] A Data Importation Q

RE: [sqlite] A Data Importation Question

2007-07-31 Thread Griggs, Donald
Hi Lee, If I answer wrongly here, I trust (and hope) someone will correct me: Regarding: "I need a way to programmatically import data from flat files..." Sqlite itself is designed to be small and simple -- for some embedded uses even the sql parser is removed. I don't think there's an api

[sqlite] A Data Importation Question

2007-07-31 Thread Lee Crain
My company's application has a need to regularly refresh an entire read-only database, at one week intervals. The COPY API call is no longer available. I have read the documentation on the .IMPORT command but it is a line item command interface. I need a way to programmatically import