creator cant handle custom database fields in mySQL views
I have created a mySQL view that grabs two date fields from a table and concatenates them into a single string fields so that the date range can be popultaed in a drop down list. Here is the mySQL field...
concat(date_format(`rate`.`StartDate`,_utf8'%d/%m/%Y'),_utf8' - ',date_format(`rate`.`EndDate`,_utf8'%d/%m/%Y')) AS `DateRange`
This works fine in mySQL however here is the problem...
I add the mySQL view to my app as a new data provider but the DateRange field defined above does not get picked up properly. Creator knows the field is a string value because it hasstring for the field but thereis no field name. When binding my drop down list to this blank name field in my data provider creator throws a NULL exception error.
When I check the properties for the DateRange field in creator (under data sources by right clicking on the field name within the views for my mySQL database) the column definition is NULL.
Have I missed something or is this a bug in creator? If it is a bug it is a massive limitation that creator cannot pickup predefined fields in mySQL views.
