I'm sorry, it seems that I've written trash. Colons are used inside
Firebird to distinguish between table columns and parameters, but not to
declare parameters in an sql string. Use @ . Juergen
Sam Carleton schrieb:
> So, it is my take that it can be either an @ or a colon (:), correct?
>
> 2010
So, it is my take that it can be either an @ or a colon (:), correct?
2010/3/20 Carlos Guzmán Álvarez
> Hello:
>
> I am using Firebird Client 2.0.1 and need do some dynamic SQL using named
>> parameters:
>>
>> UPDATE order SET qty = ? WHERE order_id = ?
>>
>> The catch is that I want the parame
-Original Message-
From: Carlos Guzmán Álvarez carlosg...@gmail.com
Date: Sat, 20 Mar 2010 11:09:01
To: For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] named parameters
Hello:
> I am using Firebird Client 2.0.1 and need do some dynamic
Hello:
> I am using Firebird Client 2.0.1 and need do some dynamic SQL using
> named parameters:
>
> UPDATE order SET qty = ? WHERE order_id = ?
>
> The catch is that I want the parameters to be named. What is the
> correct syntax for Firebird Client?
You can use sql server like named params:
You have to use colon:
UPDATE order SET qty = :content WHERE order_id = :id
Sam Carleton schrieb:
> I am using Firebird Client 2.0.1 and need do some dynamic SQL using
> named parameters:
>
> UPDATE order SET qty = ? WHERE order_id = ?
>
> The catch is that I want the parameters to be named. Â W
I am using Firebird Client 2.0.1 and need do some dynamic SQL using named
parameters:
UPDATE order SET qty = ? WHERE order_id = ?
The catch is that I want the parameters to be named. What is the correct
syntax for Firebird Client?
-
Ignore this message.
Already corrected.
Thanks.
- Mensaje original
De: Alex Castillo <[EMAIL PROTECTED]>
Para: firebird-net-provider@lists.sourceforge.net
Enviado: miércoles, 24 de enero, 2007 13:51:58
Asunto: [Firebird-net-provider] Named parameters exception
Hello,
Ho
Hello,
Hope you can help me.
I have the next update string:
"UPDATE domicilio SET [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
,[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] WHERE [EMAIL PROTECTED]"
and I create every parameter doing this:
comDomicilio.Parameters.Add(Fabric
