firebird-net-provider

[Firebird-net-provider] parameters placeholders

[Pavol S. <pa...@st...>]

hi,

is there posibility use named parameters placeholders??? It is working 
with question mark, but in more complex queries i need to use same 
parameter more then once. something like IBX :parameterName

thanx Pavol

Re: [Firebird-net-provider] parameters placeholders

[<car...@te...>]

Hello:

> is there posibility use named parameters placeholders??? It is working 
> with question mark, but in more complex queries i need to use same 
> parameter more then once. something like IBX :parameterName

I can try to implemet it, i think that can be good to use the same 
format as in the
SQL Server Provider ( for compatibility :) ) using @parameterName, any 
thoughts??




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] parameters placeholders

[<car...@te...>]

Hello:

 > please make it that way i have to use @sign in parameter name in
 > ParamsCollection too
 >
 > parameters.Add("@myparam", 1)
 > not
 > parameters.Add("myparam", 1)
 > (this is not logic, but i think, that sql provider do it this way...)
 >
 > or you will have to write strong help for this...

I have commited to the CVS the first changes for allow this i will try 
to make some tests and add NUnit tests to the CVS later today.





Best regards
Carlos Guzmán Álvarez
Vigo-Spain