"C:\Program Files\sqlite3" tmp.db
SQLite version 3.3.7
Enter ".help" for instructions
sqlite> create table t (a text);
sqlite> .s
CREATE TABLE t (a text);
sqlite> insert into t values ('Secretary');
sqlite> insert into t values ('Programmer');
sqlite> insert into t values ('Programmer II');
sqlite> select * from t;
Secretary
Programmer
Programmer II
sqlite>
On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
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]
-----------------------------------------------------------------------------
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
