Form personalization - Number

Numeric validation in form personalization

 

Trigegr event: WHEN-VALIDATE-RECORD

 

Trigger object : ACCOUNTS

 

DECODE(TRANSLATE(:ACCOUNTS.BANK_ACCOUNT_NUM,'1234567890','0000000000'),LPAD('0',LENGTH(:ACCOUNTS.BANK_ACCOUNT_NUM),'0'),'NUMBER','NOT NUMBER')='NOT NUMBER'

 

ex: if 33123-33 is entered, then decode convers the code as 00000-00 and LPAD function returns 0000000 , hense mismatchin and not Number.