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 <carlosg...@gmail.com > <mailto:carlosg...@gmail.com>> > > 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 ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
