Delete record on database view list

PHPMaker General Discussion (PHPMaker)
1

So, I have a database view where only one field is from another table.
I’ve tried to delete a record and I get the ‘cannot update the record because it would affect multiple tables’ error.
Since I don’t care to update that field from the other table, I’ve added this to Page_Load on List, naming “MyTable” with the main table name

$this->UpdateTable = “MyTable”;

but nothing changed.
Did I got this wrong? Is there another way?

2

Please put this code in “Row_Deleting” server event:

$this->UpdateTable = “MyTable”;
unset($rs[“YourFieldName”]); // ← adjust YourFieldName to your actual field name that does not exist in MyTable table.

3

It works, thank you