I have a grid that has my main data, there is a related table that contains a series of dates (visits). If a visit gets entered accidentally I want to be able to delete it. I have a form that pops up in the main grid allowing you to edit the visit, I put a delete button on the form and have a field called deleteMe. If deleteMe is 0 the record was edited if the record should be deleted I set deleteMe to the record id. It does not Delete the record. What did I miss?
This is the client side code
VerifyVisitForm.attachEvent(“onButtonClick”, function(name, command){
if(command==“delete”){
VerifyVisitForm.setItemValue(“deleteMe”,recordId);
VerifyVisitForm.validate();
}
This is the server side code.
$VerifyVisitForm->event->attach(“beforeRender”, “removeVisit”);
function removeVisit($action){
if($action->get_value(‘deleteMe’)!=0){
$id=$action->get_value(‘deleteMe’);
$sql = “DELETE FROM Visitdates WHERE id=”.$id.")";
mysql_query($sql);
$action->success();
}
}