[fpc-pascal] Trim db-fieldnames, or not?

Marc Weustink marc at dommelstein.net
Mon Apr 21 01:41:59 CEST 2008


Graeme Geldenhuys wrote:
> On 19/04/2008, Michael Van Canneyt <michael at freepascal.org> wrote:
>>  > 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)
> 
> That's is sick! And yes, MS-Access uses the square brackets.

with quoted identifiers you can do whatever you want. One of the 
examples I use why you don't want to use them is:

SELECT "select"
FROM "from"
WHERE "where"
   and "and" BETWEEN "between" and "and"
HAVING "having"
ORDER BY "order by"

Marc






More information about the fpc-pascal mailing list