Convert NULL to empty string
-
- Posts: 12
- Joined: Tue 27 Sep 2011 08:37
Convert NULL to empty string
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
-
- Posts: 12
- Joined: Tue 27 Sep 2011 08:37
Null value
We figured this out. It is a property (a collection) in the adapter where it is possible to change DBNull to empty string.