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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] QAContact: [EMAIL PROTECTED] TargetMilestone: --- @@ -72,6 +72,26 @@ clear run How often does this happen? Always Additional Information: + +------- Additional Comments From [EMAIL PROTECTED] 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"; _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
