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. Â What is the > correct syntax for Firebird Client? > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > > -- *_Juergen Thomas_* Verlags-Software 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
