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!
Joost
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
