Hi, I am trying to create a custom event to write a history record when a contract is created However, when the record is created it only shows1. -281041 not the digits in frontAlso, I am not able to get the status from the variables ROWSTATE - the event does not like it. What else can I use to record the status.Thanks

Question

Sub Contract custom event

Userlevel 3

+10

Hi,

I am trying to create a custom event to write a history record when a contract is created

However, when the record is created it only shows

1. -281041 not the digits in front

Also, I am not able to get the status from the variables ROWSTATE - the event does not like it. What else can I use to record the status.

Thanks

Userlevel 7

+30

Is the date crated column a real date column or a text column? Perhaps you need to format the sysdate there with a call to to_char?