Why is it that the database name is surrounded by double quotes and every other parameter must use single quotes?

Aaron

>Why is it that the database name is surrounded by double quotes and every other parameter must use single quotes?

You'll find it isn't only ALTER DATABASE that has that. DBISAM, if I remember correctly, went down the same path in the later versions. I think its that data is surrounded by a single quote and system objects (eg table names, column names, database names etc) are surrounded by a double quote.

Also you only need the double quotes if there is a special character in the name (eg a space)

Can't remember if Tim ever explained the underlying logic / reason for it.

Roy Lambert [Team Elevate]

Aaron,

<< Why is it that the database name is surrounded by double quotes and every
other parameter must use single quotes? >>

All ElevateDB object identifiers are referenced with double-quotes (if
necessary).   String constants are specified with single quotes.

It's the context in the SQL statement that matters.  Any time an identifier
is required:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Identifiers

it should be enclosed in double-quotes if it matches a reserved word or
contains characters like spaces that would cause an error in the parsing if
the identifier was not enclosed in double-quotes.

--
Tim Young
Elevate Software
www.elevatesoft.com