Hi Roger,
In C#, I code it like this.
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append(" SELECT * FROM MyTable WHERE );
sqlCommand.Append("Guid = @Guid ");
sqlCommand.Append("OR Guid = UPPER(@Guid) ");
sqlCommand.Append(";");
FbParameter[] arParams = new FbParameter[1];
arParams[0] = new FbParameter("@Guid", FbDbType.Char, 36);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid.ToString();
Norbert Saint Georges
Six Sigma Business Intelligence Analyst
Six Sigma Green
Rue de la Reine 5
B- 1330 Rixensart
Tel. +32 (0)28808810
www.sixsigmagreen.eu
De : Roger Montague [mailto:rogermonta...@embarqmail.com]
Envoyé : samedi 10 décembre 2011 17:08
À : Firebird-net-provider@lists.sourceforge.net
Objet : [Firebird-net-provider] Calling Parameterized Queries
Hi Listers,
This is a pretty basic question, but I havent found the answer to it yet.
In C#, how would one pass a parameter to a parameterized query, such as:
SELECT * FROM MyTable WHERE ?
Thanks,
Roger
Roger Montague
Waconia, Minnesota USA
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider