-----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<firebird-net-provider@lists.sourceforge.net>
Subject: Re: [Firebird-net-provider] named parameters

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


------------------------------------------------------------------------------
Download Intel&#174; 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
------------------------------------------------------------------------------
Download Intel&#174; 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

Reply via email to