PL/SQL get value from text field

Hi @Link,

Could you please let us know the use case? For an example, to create a custom field, event action etc. A little bit more details about what you are trying to do would help.

Thanks!

Hi Charith,

yes, I want to create an custom event. With this event I want to prevent enter more than 35 characters in a text field. If a user want to enter more than 35 characters in a text field then the event should shows an error message while saving the object.

Thank you and kind regards

Charith Epitawatta wrote:

Hi @Link,

When creating a custom event, you can select which attributes you need to be available for your event action.

Once you have selected the necessary attributes above and saved, they will appear in the available substitution fields section when you create an action for that event. You can use them in your event action as variables in your SQL block. 

Hope this helps!

Hi Charith,

thanks for replying.

Of course I know these attributes. Bute these are already in the database.

I need a value from a certain text field to check the lenght. Short: do plausibility check before saving.

Kind regards

Link wrote:

Charith Epitawatta wrote:

Hi @Link,

When creating a custom event, you can select which attributes you need to be available for your event action.

Once you have selected the necessary attributes above and saved, they will appear in the available substitution fields section when you create an action for that event. You can use them in your event action as variables in your SQL block. 

Hope this helps!

Hi Charith,

thanks for replying.

Of course I know these attributes. Bute these are already in the database.

I need a value from a certain text field to check the lenght. Short: do plausibility check before saving.

 

Kind regards

Hi Charith,

you are right. :-)

 If  LENGTH('&NEW:DATA8') > '35' Then
     Error_SYS.Record_General('Attention', ' Bankaddress Line 2 can only consists of 35 characters');
     
     rollback;
 End If;

Thank you