Convert NULL to empty string

Convert NULL to empty string

Postby oleengvoll » Mon 17 Oct 2011 16:25

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
oleengvoll
 
Posts: 12
Joined: Tue 27 Sep 2011 08:37

Null value

Postby oleengvoll » Wed 19 Oct 2011 07:32

We figured this out. It is a property (a collection) in the adapter where it is possible to change DBNull to empty string.
oleengvoll
 
Posts: 12
Joined: Tue 27 Sep 2011 08:37


Return to dotConnect for MySQL