Hi Guys,
I’m trying to do some dynamic text-work on a gridview form:
- The form is of a gridview type and will be called as a detail-form in a master/detail relationship.
- Most fields are regular select fields that convert an ID into its respective text value on another table (which works just fine)
- One field - the problem field - is an additional field that is not on the original table. It uses the ID-Field from the original table to retrieve data (several lines of text) from a different view. I've tried field types 'select', 'text' and 'multiline text' and the data is returned properly as well. But: [B]The linebreaks are removed[/B]. The data from this field is dynamically processed within the view, the original fields do not have linebreaks. I combine these values from a MySQL Server using GROUP_CONCAT, and have tried various separators (in vain so far): [LIST]
- " "
- "__SC_BREAK_LINE__ "
- Copied a linebreak symbol from a field where the linebreak was inserted via scriptcase
Cheers,
FWN