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

[bugzilla-daemon at bugzilla.ximian.com]

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.

http://bugzilla.ximian.com/show_bug.cgi?id=76372

--- 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: 
+OS: unknown
 OS Details: mono 1.1.9
-Status: NEW   
+Status: RESOLVED   
 Resolution: 
-Severity: 
+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? 
 Always
 
 Additional Information:
+
+------- Additional Comments From thomas.zoechling at gmx.at  2005-12-05 14:17 -------
+The Parameterprefix for Sqlite is ':' instead of '@'
+Example:
+Instead of 
+string sql = "SELECT firstname, lastname FROM employee WHERE firstname
+= @parm";
+Use
+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).
+Example:
+Instead of 
+ dbcmd.Parameters.Add ("parm", DbType.String).Value = "Kamil";      
+Use
+ dbcmd.Parameters.Add (":parm", DbType.String).Value = "Kamil";