firebird-net-provider

[Firebird-net-provider] may be bug

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

hi,

i have problem with named parameters...

i have parameter @p10 and this parameter make problems... When i rename 
it to @px its working...

problem is exception TOKEN UNKNOW line x char y "0"

p.

Re: [Firebird-net-provider] may be bug

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

HEllo:

> i have problem with named parameters...
> 
> i have parameter @p10 and this parameter make problems... When i rename 
> it to @px its working...
> 
> problem is exception TOKEN UNKNOW line x char y "0"

I´m triying to reproduce this withou result, i have a test case like this :


FbConnection myConnection = new FbConnection(connectionString);

myConnection.Open();

FbTransaction myTransaction = myConnection.BeginTransaction();			
FbCommand myCommand = new FbCommand("select * from TEST_TABLE_01 
where 		INT_FIELD = @p10", myConnection, myTransaction);
	
myCommand.Parameters.Add("@p10", FbType.Integer, "INT_FIELD").Value = 1;

myCommand.Prepare();

myCommand.ExecuteNonQuery();

myDataAdapter.Dispose();
myCommand.Dispose();
myConnection.Close();



It's correct???





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] may be bug

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

im using this
myCommand.Parameters.Add("@p10", my_value);

and try put there 11 parameters named from @p0 to p@11...

p

Re: [Firebird-net-provider] may be bug

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

Hello:

> im using this
> myCommand.Parameters.Add("@p10", my_value);
> 
> and try put there 11 parameters named from @p0 to p@11...


It's a problem with named parameters replacement with ?, now it will be 
made using Regular Expressions, it´s fixed in CVS now, i think now will 
work as expected, thanks very much.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.