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 SQL
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:
Use a connection within a using clause.
using (FbConnection connection =
OpenConnection())
{
using (FbCommand command = new
FbCommand(commandName, connection))
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