Derived table field (type memo) not populated in class object in class pane

[Former Member]

I have created a derived table in designer to retrieve a data segment from a Postgresql DB.

Query is:

select public.table_attribute_map.instance_fk as id, public.table_attribute_value.free_text as service_provider from public.table_attribute_map,public.table_attribute_value where

public.table_attribute_value.table_attribute_map_fk=public.table_attribute_map.id and public.table_attribute_map.attribute_fk='375546'

The query parses OK. And I can see the query result when I view Table Values.

But when I move the class from the designer pane to the class pane, the field service-provider does not appear.

Very strange.

I'm told this may be the result of the public.table_attribute_value.free_text field being of type memo.

Any ideas? Comments? work-arounds?

[Former Member · Accepted solution]

memo is an unsupported data type. You may need to convert it to, say, varchar(2000) or something similarly suitable in a view and use the view instead of the table.