Re: [sqlite] One more on .import

2010-05-06 Thread Matt Young
Righto yes, a simple macro somewhere in the path to correct for row size On 5/6/10, Jim "Jed" Dodgen wrote: > On Thu, May 6, 2010 at 3:56 PM, Simon Slavin wrote: >> >> On 6 May 2010, at 11:19pm, Matt Young wrote: >> >>> I need a version of import that reads what it can, filling in defaults >>> w

Re: [sqlite] One more on .import

2010-05-06 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/06/2010 04:55 PM, Matt Young wrote: > It could be done and only adds a few bytes to the binary since the > code would simply check the 'ignore on import setting of .mode' before > taking error action for missing or too many columns. The issue i

Re: [sqlite] One more on .import

2010-05-06 Thread Jim "Jed" Dodgen
On Thu, May 6, 2010 at 3:56 PM, Simon Slavin wrote: > > On 6 May 2010, at 11:19pm, Matt Young wrote: > >> I need a version of import that reads what it can, filling in defaults >> when too few columns, discarding data when too many. > > Great.  Go ahead and write one.  You have our permission. > >

Re: [sqlite] One more on .import

2010-05-06 Thread Matt Young
It could be done and only adds a few bytes to the binary since the code would simply check the 'ignore on import setting of .mode' before taking error action for missing or too many columns. I will look at the source On 5/6/10, Simon Slavin wrote: > > On 6 May 2010, at 11:19pm, Matt Young wrote:

Re: [sqlite] One more on .import

2010-05-06 Thread Simon Slavin
On 6 May 2010, at 11:19pm, Matt Young wrote: > I need a version of import that reads what it can, filling in defaults > when too few columns, discarding data when too many. Great. Go ahead and write one. You have our permission. Simon. ___ sqlite-us

[sqlite] One more on .import

2010-05-06 Thread Matt Young
I need a version of import that reads what it can, filling in defaults when too few columns, discarding data when too many. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users