[Mono-devel-list] RowFilter, Select expression, DataTable.GetErrors() bugs?
banditaras at gmail.com
Tue Aug 2 03:37:53 EDT 2005
I'm using mono 126.96.36.199 and the MySql connector (188.8.131.5263)
First, I'm having this problem with the RowFilter expression.
I want to do a DataTable.Select(someFilterHere), but if the filter
contains a single quote, I cannot escape it. For example
string filter = "ProductTitle = 'aa''aa'"; //invalid expression
string filter = "ProductTitle = 'aa\\'aa'"; //invalid expression
string filter = @"ProductTitle = 'aa\'aa'"; //invalid expression
The first expression works fine in .Net.
Next, I perform an update using MySqlDataAdapter.Update method.
After the update is completed, DataTable.GetErrors() returns all rows
Yet, I can see in the database that all records have been updated
successfully (except from one, which i'm trying to track down, but I
cant :) ).
I'm wondering if anyone else has encoutered any of these problems, Mr.
Google knows nothing of it.
Thanks in Advance
P.S Development platform is a linux box, if it makes any difference.
More information about the Mono-devel-list