Re: updating all text items in a block programmatically with a loop

Use the NAME_IN function. Instead of a field name type:

NAME_IN(VARIABLE); Where VARIABLE is a varchar2 variable that is storing the name of the field you want to manipulate.

-- 
Joe Strano
Dulcian, Inc.
Rasputin wrote:


> 

> I would like to be able to update the values all other text items after


> editing one of the text items using a loop in a POST_TEXT_ITEM trigger.

> I don't want to have to hard code references to the item names in my

> assignment statements, but their doesn't seem to be a way to set the

> value of a text item using SET_ITEM_PROPERTY. This function seems to

> provide every property except for the value of text items. I can get the

> first and last item ids using

> GET_BLOCK_PROPERTY('my_block_name',FIRST_ITEM/LAST_ITEM) and

> FIND_ITEM('my_block_name'||GET_BLOCK_PROPERTY('my_block_name',LAST_ITEM),

> but then I can't assign the new value (I want to use the REPLACE

> function to search/replace a string) without hard-coding the name of

> each text item.

> 

> Does anyone have any ideas on how to get around this?

> 

> Thanks

> --

> Steven W. Shaw

> Programmer - Pacific Ridge Data Resources (http://www.crem.com)

> work: sshaw_at_crem.com

> home: sshaw_at_west.net