Trigger On Creation

[RD_Man]

Hello,

I need to get data entered by a user and uppercase the value "On Creation".

code:
TRIGGER PROCEDURE FOR CREATE OF Bank.
Update Bank Set (Id) = (UCase(Id)).

When this trigger fires, the data does NOT appear to be available for update. I assume it is still in a buffer somewhere.

Is there a way to manipulate data Pre-Save?

P.S. I have no access to the UI or Write Trigger.

 

[parul]

You should not have update statement in triggers.

You have OLD and NEW buffers avail in write triggers. Using these you achive what you want.

Have a look at programming handbook chapter 11 Database triggers.

-Parul.

 

[RD_Man]

Parul,

I am bound to a canned software package that has the Write Trigger compiled in. I do not have access to this trigger. Nor do I have access to the UI code.

Is there any options to force an ID field to be uppercased upon creation or immediatly therer after?

Mike

 

[sridevi.stalin]

Why don't you try the CAPS()Function.