Home/ Questions/Q 4143
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-12-14T18:45:18+00:00

Apply validation on Delete button when click

  • 0
  • 0

Hi,

I have customer table, and this customer information is called in sales invoice form. Now if i delete any custom then it check first either customer information is exist in sales table or not, if yes then delete button give message that custom already exist, you can not delete.

 

Please guide me how to call this validation in button.

apex
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. This is just to give you a flavor of how it works in simple case.

    Assuming you have an item CUSTOMER_ID, table CUSTOMER_INFO and a button called DELETE.

    While in the design mode of your page;

    1. GO to Processing
    2. Right click on Validating
      1. Create Validation
        1. Identification = Check if exists
        2. Validation:
          1. Type No Rows returned
          2. SQL Query = SELECT NULL FROM CUSTOMER_INFO WHERE CUSTOMER_ID = :CUSTOMER_ID
        3. Error:
          1. Error Message = custom already exist, you can not delete.
        4. Server-side Condition:
          1. When Button Pressed = DELETE

    It’s just a sketch you may want to accommodate to your needs.