Hi Mark.

How about just creating a field in the view that is the SUBSTR?

Dan

>Hi,
>
>In some cases I want to use memo fields in the grid of a clistobjedit and I limit the memo field by using the substr function [e.g. substr(v_view.cdescription,1,50)]. When a column of the grid in clistobjedit has that kind of limited memo field as a controlsource, clicking on the header causes problems in the setorder method of the grid. Up till now I solved the problem by subclassing and changing the setorder method in:
>
>

LPARAMETERS tcControlSource, tcTagName
>** If memo fields are used  (e.g. SUBSTR(v_source.memofield,1, 50))
>** strip the string function
>
>IF AT('(',tcControlSource) > 0 THEN
>	tcControlSource = RIGHT(tcControlSource,LEN(tcControlSource)-AT('(',tcControlSource))
>	tcControlSource = LEFT(tcControlSource,AT(',',tcControlSource)-1)
>ENDIF
>
>IF PCOUNT() < 2 THEN
>	DODEFAULT(tcControlSource)
>ELSE
>	DODEFAULT(tcControlSource, tcTagName)
>ENDIF

>
>Since a lot of forms in the framework use this grid, a lot of subclassing is involved.
>Is there a better to get the same result?
>
>Mark