🛡️
ZenDevX
  • Overview of ZenDevX Design Studio
  • Installation & Setup
    • Prerequisite
  • Getting Started
    • Login Process
    • Homepage
    • Dashboard
    • Project Explorer
  • Project Info.
    • Project Info.
      • Create New Project
      • Edit existing Project
      • Open existing Project
      • Remove Project
      • Close Project
  • Session Variables
  • Generate Code
  • Page Information
    • Page Information
      • Edit Page Info
      • Create New Page
        • Page Design Interface
          • Building Page Layout
      • Remove Page
      • Generate Code
      • Preview Page
  • Web-service
    • Web-service / REST-API
      • Create New Web-Service
      • Open existing Web-service
      • Remove Web-service
      • Generate Code (Web-service)
  • Database Management
    • Database Info.
    • Create Table
    • Modify Table Structure
    • Drop Table
  • Query Builder
    • Query Builder
      • Query Types
        • Insert Query
        • Update Query
        • Delete Query
        • Select Query
          • Join Multiple Tables in Query
          • Condition (Where Clause)
          • Sorting Data
    • Generate Web-service
  • Actions (the Power Within)
    • Action Wizard
      • Definition Group
        • Define Variable
        • Set NULL
        • Set Unique ID
        • Set Value
        • Perform Formula
        • Assign Value
        • Reset Form
        • Read/Write Session Variables
        • Library Functions
      • UI Group
        • Information Dialog
        • Set Focus to Control
        • Open Window/Page
        • Enable/Disable
        • Display/Hide
        • Show/Hide Modal
        • Change Tab
      • Actions Group
        • Data Exchange
        • Upload Image
        • Call UDF
        • Return value from UDF
        • Reload Select List
        • Manual Code
      • Condition & Loop
        • IF...THEN...ELSE
        • Break
        • FOR... Loop
        • Duplicate Check
        • Delete Check
        • User Confirmation
      • Database
        • Execute Query
        • Assign Query Result to
        • Return Value
        • Execute Stored Procedure
        • Generate Document #
        • Return Auto Increment Value
      • Data Table
        • Remove Current Row
        • Get Number of Rows
        • Loop in Table Rows
        • Reload Table Data
        • Fetch Row Value
  • Deploying Web Application
    • Deploying Web Application
Powered by GitBook
On this page

Was this helpful?

  1. Actions (the Power Within)
  2. Action Wizard
  3. Condition & Loop

Duplicate Check

PreviousFOR... LoopNextDelete Check

Last updated 4 years ago

Was this helpful?

This will take one to the True part (If duplicate value exist) where one have to add all the actions required to be performed. Once this is completed click on next button to go to the False part (If duplicate value does not exist) and add all the actions required to be performed.Whenever there is a need to check for duplicate value in database use this Action. Duplicate Check is similar to If...Then..Else the only difference is that here the value is checked from database.

For this action to work one needs to first create a SQL query and related Web-service as it is this that is called by this Action.

This action also has three parts or steps.

In the first part select the control whose value one wants to check for duplicate in database, then select the Data source that is the SQL Query that will be executed to check for duplicate value in database and finally set the parameters of the selected query.

Now click next button.