[Firebird-net-provider] How do you use parameters?

[David V <dav...@ho...>]

How do you use parameters with firebird, the following code:

fbCommand.CommandText = "INSERT INTO properties(id, propName, propValue) 
VALUES (1, 'title', :propValue)";

fbCommand.Parameters.Add("@propValue", 
FirebirdSql.Data.Firebird.FbType.VARCHAR, 100, "propValue");
fbCommand.Parameters[0].Value = "some value";

fbCommand.Prepare();
fbCommand.ExecuteNonQuery();

Throws the exception:

FirebirdSql.Data.Firebird.FbException: Dynamic SQL Error
SQL error code = -206
Column unknown
propValue
At line 1, column 147.

   at FirebirdSql.Data.Firebird.FbCommand.Prepare()

The column propValue does exist. Any ideas of what I am doing wrong?





_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963