Posted: 4 Nov 2019 6:50 EST Last activity: 11 Dec 2019 23:01 EST
How to search if a value exists in table
I am trying to delete records via GUI. I have a text input in my section mapped with property (.EID) which intakes employee ID (for example 1) and when i click a button 'delete' that particular record should be deleted from DB. I have written an activity that successfully deletes. But I want to display a message if the entered employee ID is not present in the table. For example if I have already deleted record 1 and the user again tries to delete record 1 it should display a amessage saying "employee doesnt exist, please enter existing ID". I have used obj-open->obj-delete->commit to delete the records. Please help me how to achieve this.
Thanks, I will check it out, but meanwhile i have tried something, i am attaching a doc, please check and help me. Message is set for both true and flase output of when condition in property-set-messages.