Constant values

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Edward Diener Mon, 25 Nov 2002 04:45

#11362

Author: Edward Diener
Date: Mon, 25 Nov 2002 04:45

6 lines
1249 bytes

Do constant values in Interbase SQL statements have to be in single or
double quotes if they do not contain space characters ? For SQL statements
with other database systems is it a general rule that constant values must
be in single or double quotes, or is it database system dependent issue ?
Can one ever go wrong placing constant values in single or double quotes in
SQL ?

Re: Constant values

#11363

Author: Frank Gruber
Date: Mon, 25 Nov 2002 09:42

19 lines
1903 bytes

> Do constant values in Interbase SQL statements have to be in single or
> double quotes if they do not contain space characters ? For SQL statements
> with other database systems is it a general rule that constant values must
> be in single or double quotes, or is it database system dependent issue ?
> Can one ever go wrong placing constant values in single or double quotes
in
> SQL ?

It depends on the dialect you are using.
In Dialect 3 (the prefered one) you have to use single quotes for
string constants, whereas double quotes have to be used for specifiers
like colum and table names (if they are case sensitive or contain spaces).

In Dialect 1 AFAIK you could use single and double quotes for constants.
Specifiers do not need any delimiters because spaces are not allowed and
they are not case sensitive.

Regards,
Frank.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads