Sam Hunt wrote:

>Ivan Cruz wrote:
>
>
>
>>delphigurusam wrote:
>>
>>
>>
>>
>>
>>> NEW.DISPLAY_NAME=UPPER(NEW.LAST_NAME)+', '+NEW.FIRST_NAME+'
>>>'+NEW.MI;
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>Try
>>
>>NEW.DISPLAY_NAME=UPPER(NEW.LAST_NAME)||', '||NEW.FIRST_NAME||' '||NEW.MI;
>>
>>
>>
>>Ivan.
>>
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Visit http://firebird.sourceforge.net and click the Resources item
>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>>Also search the knowledgebases at http://www.ibphoenix.com
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>It ran without error.
>I'll strip out my app code that was updating this and see what happens.
>Thx so much.
>Sam H.
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>

Well... this trigger doesn't chg the display_name field when the
specified fields are edited and posted from the app.
Just for kicks, I tried removing (saved my chgs to the trigger) for all
of the conditions for constituent type 1, except the chg on last_name,
then I chgd the last name and it still did not update the displa_name
field, or maybe I should state more correctly that the display_name
"looks" like it's blank.

If anyone has any ideas, I'd be glad to try them.
Thx
Sam H.