I have a memo field "Description" in my custom schema. I wanted to display this field in my delivery.
I added this field in Query activity using "Add data" option.
But the field is not moving to next transition. I didn't get any error too.
I was trying to store a long text field. So I used memo data type.
Later i tried String type with length = 2000 for field Description. This worked fine for me.
You cannot access memo field from Query (Additional Data) since it is not a SQL Field. You can fetch it in the Data Extraction activity where you can able to view it in Display Target (or) directly in the Script tab of the Recurring Delivery if your schema is linked to Delivery schema.
I don't think you can display a memo since it is not an SQL field but an XML one.
you need to use some method like Substring(MyMemo,0,255)
can you provide some printscreens plz?