Article View: borland.public.interbase.sql
Article #11363Re: Constant values
From: Frank Gruber
Date: Mon, 25 Nov 2002 09:42
Date: Mon, 25 Nov 2002 09:42
19 lines
1903 bytes
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.
Technical Details
Message-ID:
<3de1f08c$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!news-raspail.gip.net!news.gsl.net!gip.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3de1aa35@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,7c1443ff29451e6c X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-11-25 02:09:22 PST From: "Frank Gruber" <HVFDMIPUMFPS@spammotel.com> Newsgroups: borland.public.interbase.sql References: <3de1aa35@newsgroups.borland.com> Subject: Re: Constant values Date: Mon, 25 Nov 2002 10:42:36 +0100 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 217.231.182.65 Message-ID: <3de1f08c$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1038217356 217.231.182.65 (25 Nov 2002 01:42:36 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!news-raspail.gip.net!news.gsl.net!gip.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail