This discussion is archived
4 Replies Latest reply: Nov 3, 2013 3:20 PM by newbi_egy RSS

delete checked button

newbi_egy Explorer
Currently Being Moderated

on apex.oracle.com

elbyaly

eyesmagicx@yahoo.com

decuk9

 

in the application (another of patients) , the (master detail) page , there is a button (delete checked) of the tabular form , this item has a condition (exists(sql returns at least one row) ,

1- i want to know what this condition means .

i think it means : (do not show the button if the query does not return at least one row) , right ?

 

2- i can not see it except when i edit a patient , and i do not want this , i want to see it when i try to insert a patient too ? how ?

 

thanks a lot

  • 1. Re: delete checked button
    LA-APEX-DEv Explorer
    Currently Being Moderated

    in the application (another of patients) , the (master detail) page , there is a button (delete checked) of the tabular form , this item has a condition (exists(sql returns at least one row) ,

    1- i want to know what this condition means .

    i think it means : (do not show the button if the query does not return at least one row) , right ?

    • Yes, you are correct.

     

    2- i can not see it except when i edit a patient , and i do not want this , i want to see it when i try to insert a patient too ? how ?

    • You can change to never condition.
    • i want to see it when i try to insert a patient too (There is no reason to delete a record when there is no record).
  • 2. Re: delete checked button
    newbi_egy Explorer
    Currently Being Moderated

    >

    • i want to see it when i try to insert a patient too (There is no reason to delete a record when there is no record).

    may be when i insert a patient and give him two tests for example , i want to undo this action and remove one test of the two . how can i do it if the button

    is not there ?

     

    -- the problem now , when i remove the condition , and click the button to delete a test of the two tests , the name and any data of the patient is also deleted not just the test i want ?

  • 3. Re: delete checked button
    LA-APEX-DEv Explorer
    Currently Being Moderated

    may be when i insert a patient and give him two tests for example , i want to undo this action and remove one test of the two . how can i do it if the button

    is not there ?

    • If that the case, you have to use some kind of condition. For instance, you can set a value in one of your table column to Completed = 'Y' so that you can use that field value to display the button while you're still testing.

    -- the problem now , when i remove the condition , and click the button to delete a test of the two tests , the name and any data of the patient is also deleted not just the test i want ?

    • Is the test and patient records stored in the same table? If they are not, check to see if you have a constraint of primary and foreign key has cascading deleting trigger.
  • 4. Re: delete checked button
    newbi_egy Explorer
    Currently Being Moderated

    > If that the case, you have to use some kind of condition.

    i did not understand that .

    2- >Is the test and patient records stored in the same table?

    no , and i have a primary and foreign key has cascading deleting trigger. but i think this should happens if i try to delete the master then the detail is deleted not

    vice versa ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points