Article View: borland.public.cppbuilder.database.multi-tier
Article #118Re: Oracle SQL params from IDE
From: Leif Suonvieri
Date: Sun, 05 Mar 2006 15:15
Date: Sun, 05 Mar 2006 15:15
13 lines
1429 bytes
1429 bytes
pcerdaz wrote: > Hy all, I'm working on a SQL from C++Builder BDS2006 with next > syntax problem: the IDE use ":" before the name of parameter > but Oracle does not accept this character. The Oracle > accept "&" character but IDE don't understand it. > How can I solve this problem? > Thanks in advance. I don't think I understand your problem. The colon in Borland will only be used locally to substitute the named parameter for its value, before it is sent to Oracle, so Oracle won't see it at all. /Leif
Technical Details
Message-ID:
<440b0098$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4405c64b$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: fcd2b,2207e430eb60e979 X-Google-Attributes: gidfcd2b,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Sun, 05 Mar 2006 16:15:29 +0100 From: Leif Suonvieri <leif.s@removethis.hem.utfors.se> User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Re: Oracle SQL params from IDE References: <4405c64b$1@newsgroups.borland.com> In-Reply-To: <4405c64b$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 84.218.35.103 Message-ID: <440b0098$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1141571736 84.218.35.103 (5 Mar 2006 07:15:36 -0700) Lines: 13 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail