On Sat, 19 Apr 2008, Joost van der Sluis wrote:
> Op zaterdag 19-04-2008 om 22:08 uur [tijdzone +0200], schreef Michael
> Van Canneyt:
> >
> > On Sat, 19 Apr 2008, Joost van der Sluis wrote:
> >
> > > Op vrijdag 18-04-2008 om 22:06 uur [tijdzone +0200], schreef Michael Van
> > > Canneyt:
> > > >
> > > > IMHO, no trimming should be added, because databases can have fields
> > > > with spaces. Weird, but true.
> > >
> > > Not at the begin or end, I hope?
> >
> > Even there:
> >
> > home: >fisql /home/firebird/contacts.fb
> > Database: /home/firebird/contacts.fb
> > SQL> create table test ("my field " int);
> > SQL> show table test;
> > my field INTEGER Nullable
> > SQL> alter table test add " another field" int;
> > SQL> show table test;
> > my field INTEGER Nullable
> > another field INTEGER Nullable
> > SQL> show table test;
> > my field INTEGER Nullable
> > another field INTEGER Nullable
> > SQL> select " another field" from test;
> >
> > another field
> > ==============
> > <null>
> >
> > SQL> select "another field" from test;
> > Statement failed, SQLCODE = -206
> > Dynamic SQL Error
> > -SQL error code = -206
> > -Column unknown
> > -another field
> > -At line 1, column 24
> >
> > Try and find where your query goes wrong :)
>
> That is just sick!
It is.
Courtesy of MS-Access users... That was the first to support it, AFAIK.
(although access uses [] instead of "", as far as I remember)
Michael.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
