[Mono-devel-list] RowFilter, Select expression, DataTable.GetErrors() bugs?
bandito
banditaras at gmail.com
Tue Aug 2 03:37:53 EDT 2005
Hello all.
I'm using mono 1.1.8.2 and the MySql connector (1.0.4.20163)
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
as erroneous.
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
George Chatzigeorgiou
P.S Development platform is a linux box, if it makes any difference.
More information about the Mono-devel-list
mailing list