Please enable JavaScript to view this site.

Navigation: Advanced topics > Events > Sample events > Database

Check for related records before deleting the current one

Scroll Prev Next More


Before deleting a record in the Orders table, check for related items in the OrderDetails table. Add the following code to the List page: Before record deleted event.




dynamic tblModels = GlobalVars.dal.Table("Order_Details");
XVar rs = tblModels.Query("OrderID='" + deleted_values["OrderID"].ToString() + "'", "");
XVar data = CommonFunctions.db_fetch_array(rs);
  return false;
  return true;

See also:

Database API

Check if specific record exists

Master-details relationship between tables