I am attempting to concatenate 6 fields from a table into a single field in a view. A UDF formats the text from the 6 fields. I expected a memo field to result, but instead get a string too long error message.
The SELECT statement is something like this:
SELECT ;
MYFUNCTION(field1,field2,field3,field4,field5,field6) ;
FROM MyTable ;
...
where fields field1 to field6 are character fields 254 characters in length. The UDF returns a text string that is greater than 254 characters in length.
I've tried setting the view's NoDataOnLoad property to .F., then changing my resulting field's DataType to 'M' with DBSETPROP before requerying the view. I still get the same error message. Can such concatenation be done?
The SELECT statement is something like this:
SELECT ;
MYFUNCTION(field1,field2,field3,field4,field5,field6) ;
FROM MyTable ;
...
where fields field1 to field6 are character fields 254 characters in length. The UDF returns a text string that is greater than 254 characters in length.
I've tried setting the view's NoDataOnLoad property to .F., then changing my resulting field's DataType to 'M' with DBSETPROP before requerying the view. I still get the same error message. Can such concatenation be done?