Re: [sqlite] Error in SQLite's CSV output

[T&B]

Hi All,

On 18/10/2006, at 3:08 AM, Dennis Cote wrote:
You could try using the line mode output. It puts each field on a  
line of its own, and separates each record with a completely blank  
line. A sample is shown below.

   sqlite> select * from t2;
       a = 1
       b = 2

       a = 3
       b = 4

I don't think that will work, since b could conceivably contain  
something confusing, such as:

"The solution to the simultaneous equations is:

      a = 77
      b = 5
"

Also , there's a lot more overhead to parse the output, since the  
separators are different before each value, than a consistently  
delimited output.

Thanks,
Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------