Page 1 of 1

Convert NULL to empty string

Posted: Mon 17 Oct 2011 16:25
by oleengvoll
Hi! We are testing MySQLDataTable as datasource for a datagrid. We have a MySQL DB with a table of 30 fields. 25 of them are string field, which not accept NULL. When making a new record in this table, we start with data in only two fields. Is it possible to convert NULL to empty string so we dont have to set the 25 other fields to blank? Thanx. Ole

Null value

Posted: Wed 19 Oct 2011 07:32
by oleengvoll
We figured this out. It is a property (a collection) in the adapter where it is possible to change DBNull to empty string.