I have found which is the condition for get the error. I get this error when a I put in the "where" clause a varchar value.

SQL = "select CATE_ID from T_CATEGORIAS WHERE CATE_NOMBRE='@v_categoria'"
.....
cmd.Parameters.Add("@v_categoria", FbDbType.VarChar).Value = "Cat1"
....
While dr.Read   --- Fail


If I put an integer value in the where condition It works fine.


I have used a Firebird 1.5 bd

Thanks


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to