From: <car...@te...> - 2003-03-03 10:46:23
|
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. |