>From experience. Most "free form" output routines I have used utilizes the content of the first row to establish the width of "columns." (i.e. Reflected in the result per your "Administrative Assistant")
If you can "throw away" your first row of output, you could insert a first row in your table with "X"'s in all positions out to your maximum column widths. Export the data and delete the first line. Fred > -----Original Message----- > From: John Salerno [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 29, 2006 11:39 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Re: two questions about formatting output > > > Alright, one final note, because now I'm really confused. Here was my > original row data: > > Secretary, Programmer, Programmer II > > It displayed like this: > > title > ---------- > Secretary > Programmer > Programmer > > I changed Secretary to Administrative Assistant and now it > shows like this: > > title > ---------- > Administrative Assistant > Programmer > Programmer II > > So why didn't it expand for Programmer II, but it does expand for AA? > > Thanks, > John > > > > > > > On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote: > > Just as a follow-up, I noticed that one of my columns *did* > expand to > > fit a longer name, yet another column didn't. Could it be > because the > > one that expanded contained a string of a single word, while the > > column that didn't expand contained multiple words, i.e. 'Programmer > > II'? > > > > Thanks. > > > > > > > > On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote: > > > Is it possible to change the width of columns in column > mode in some > > > general way? What I mean is, I know I can do .width X X X > etc., but > > > that requires knowing how many columns you have. Is there > some way to > > > set it so that the column will simply expand to fit the > information? > > > > > > Second, I created a row entry like this: > > > > > > salary double(6, 2) > > > > > > and then entered a number such as 45000.00, but the > output shows it as 45000.0 > > > > > > Maybe this comes from ignorance of how SQL works in general, but > > > shouldn't it show the second 0, since I typed it that way and I > > > declared the field to have 2 decimal places? > > > > > > Thanks, > > > John > > > > > > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
