clear block with initial value

Hello,

I'd like to clear a block with an initial value.
I tried it with

GO_BLOCK('MY_BLOCK_TO_CLEAR');
CLEAR_BLOCK(No_Validate);

But everything from the block except the field with
an initial value is cleared.

1) It really depends on what end result you are looking for. If you don't want that value in there (item a) anymore, then set the initial_value property for that particular item to null on the property sheet.

1a) If you want the initial value to appear conditionally, do the step above and write code on the when-val-item trigger of item b to populate item a.

2) You may be able to add the statement:
:item_a := null;
after your clear block, but I'm not sure what that will do to your record status. It might change it from 'NEW' to 'INSERT' which opens up a new set of problems.

3) Otherwise, that is normal forms functionality to show those initial values when your cursor is in the block in question on a new record. Your record status should be 'NEW' so there should be no locking or navigation issues unless you are populating other fields in the record (like from a when-new-rec-inst trigger).

If this does not help, expand on your explanation of what you are trying to do a little more.