Check for related records before deleting the current one

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);
if(data)
{
  return false;
}
else
{
  return true;
}

See also:

•Database API

•Check if specific record exists

•Master-details relationship between tables