Forum Post: Loop Records And Satisfy A Given Condition.

  • Thread starter Thread starter shilpi.agarwal3373
  • Start date Start date
Status
Not open for further replies.
S

shilpi.agarwal3373

Guest
Hi all, I have defined a table Customer which contains 2 fields Custid (PK) and custname in sql server2014. I want to validate records with unique custname in my rollbase app through trigger type Validate Record Data 'before create' a new record. When I create a new customer record then it should validate the records with custname whether a new custname does not match with existing customer name.If new Customer Name matches with existing one then an alert should appear 'Customer name ... already exists'. So how to loop through all records that satisfy a condintion in rollbase?

Continue reading...
 
Status
Not open for further replies.
Back
Top