[Firebird-net-provider] Calling Parameterized Queries

2011-12-10 Thread Roger Montague
Hi Listers, This is a pretty basic question, but I haven't 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 ---

Re: [Firebird-net-provider] Calling Parameterized Queries

2011-12-10 Thread Norbert Saint Georges
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

Re: [Firebird-net-provider] Calling Parameterized Queries

2011-12-10 Thread Roger Montague
Hello Norbert, Thank you for your response! So, Firebird SQL does accept named parameters. That is good to know. Thanks Again, Roger From: Norbert Saint Georges [mailto:norbert.saint-geor...@sixsigmagreen.eu] Sent: Saturday, December 10, 2011 12:08 PM To: Firebird-net-provider

Re: [Firebird-net-provider] Calling Parameterized Queries

2011-12-10 Thread Helen Borrie
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. >