how to use parametric queries from .NET with Firebird?
I have always been using parameters with stored procedures. like this
FbCommand cmd = new FbCommand("select * from
SP_myprocedure(?);");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@myparameter", FbDbType.Text).Value =
myparameter;
this works very well. but now I have just a query where I need to add
several parameter inputs. I have changed the CommandType to Text and put
the query into command for example "select field1, field2 from table1
where field1=:myparameter;"
but can't get it to work. how should it be done?
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
