I'll definitely move on to using Python to work with SQLite, so I guess this won't be a problem eventually, but for now the command line program is a very easy way to test out things and just use a database on the fly, without having to write the extra code involved in connecting to it via a separate language.
On 8/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"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? > > Please do not confuse "SQLite" and the command-line shell. The command-line shell is a small (and stupid) program that uses SQLite to access an SQLite database. The complete source code to the command-line shell is in the file "shell.c". The command-line shell is rather limited in what it can do in terms of output formatting. If you need something more elaborate (which you apparently do) then I would suggest writing a short script in your favorite dynamic language to open the database, extract the information you want, then present it in whatever format seems appropriate. A full-featured language is a much better tool for doing that sort of thing than a simple command-line shell. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
