Re: [Firebird-net-provider] named parameters

[VS-Polis <po...@vs...>]

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/3/20 Carlos Guzmán �lvarez <car...@gm... 
> <mailto:car...@gm...>>
>
>     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:
>
>
>     UPDATE order SET qty = @content WHERE order_id = @id
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
>   
>

-- 

*_Juergen Thomas_*
Samlaendische Str. 3
13189 Berlin

Germany