🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #118

Re: Oracle SQL params from IDE

#118
From: Leif Suonvieri
Date: Sun, 05 Mar 2006 15:15
13 lines
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-mail
References: <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