How can I apply condition to Insert data in Oracle Forms 6i
Clash Royale CLAN TAG #URR8PPP How can I apply condition to Insert data in Oracle Forms 6i I have table DOC_CUST_PRODUCT (DOC_CODE, CUST_CODE, P_CODE) DOC_CUST_PRODUCT (DOC_CODE, CUST_CODE, P_CODE) I want to restrict insertion and show message when DOC_CODE has more than 5 different CUST_CODE DOC_CODE CUST_CODE SELECT COUNT(DISTINCT CUST_CODE) INTO Y FROM BP_DOC_CUST_PRODUCT WHERE DOC_CODE = :DOC_CODE; IF NVL(Y,0) > 4 THEN MESSAGE('Sorry, Can Not Entry More Than 5 Chemist...'); MESSAGE('Sorry, Can Not Entry More Than 5 Chemist...'); but it doesn't work. Start by fixing your keyboard. Its shift key seems to be blocked. – JB Nizet 3 hours ago Writing all uppercase is considered SHOUTING and rude. But more importantly your question lacks a lot of information. Please read: stackoverflo...