[Mono-bugs] [Bug 76372][Nor] Changed - Sqlite program hangs when using parameters

bugzilla-daemon at bugzilla.ximian.com bugzilla-daemon at bugzilla.ximian.com
Mon Dec 5 14:17:18 EST 2005

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by thomas.zoechling at gmx.at.


--- shadow/76372	2005-10-08 10:57:44.000000000 -0400
+++ shadow/76372.tmp.27503	2005-12-05 14:17:18.000000000 -0500
@@ -1,14 +1,14 @@
 Bug#: 76372
 Product: Mono: Class Libraries
 Version: 1.0
+OS: unknown
 OS Details: mono 1.1.9
-Status: NEW   
+Status: RESOLVED   
+Severity: Unknown
 Priority: Normal
 Component: Sys.Data.SqlClient
 AssignedTo: mono-bugs at ximian.com                            
 ReportedBy: nazgul at omega.pl               
 QAContact: mono-bugs at ximian.com
 TargetMilestone: ---
@@ -72,6 +72,26 @@
 clear run
 How often does this happen? 
 Additional Information:
+------- Additional Comments From thomas.zoechling at gmx.at  2005-12-05 14:17 -------
+The Parameterprefix for Sqlite is ':' instead of '@'
+Instead of 
+string sql = "SELECT firstname, lastname FROM employee WHERE firstname
+= @parm";
+string sql = "SELECT firstname, lastname FROM employee WHERE
+firstname = :parm";
+There is also an issue with the Name Property of the parameters:
+You will have to add the prefix to the Parametername (I am currently
+working on a patch to fix that).
+Instead of 
+ dbcmd.Parameters.Add ("parm", DbType.String).Value = "Kamil";      
+ dbcmd.Parameters.Add (":parm", DbType.String).Value = "Kamil";      

More information about the mono-bugs mailing list