Hi Helen,
Thanks for the clarification.
Your book is my bible!
Roger
-Original Message-
From: Helen Borrie [mailto:hele...@tpg.com.au]
Sent: Sunday, December 11, 2011 1:03 AM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provide
At 07:43 AM 11/12/2011, Roger Montague wrote:
>Content-Type: multipart/alternative;
>boundary="=_NextPart_000_00BA_01CCB739.56AABA30"
>Content-Language: en-us
>
>Hello Norbert,
>
>Thank you for your response!
>
>So, Firebird SQL does accept named parameters. That is good to know.
>
-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Calling Parameterized Queries
Hi Roger,
In C#, I code it like this.
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append(" SELECT * FROM MyTable WHERE );
sqlCommand.Append("Guid = @Guid ");
sq
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