Update multiple records on the List page

To update multiple records on the List page at the same time, you can create a new Update selected button, then choose records on the List page and click the Update selected button.

1. Proceed to the Page Designer screen.

2. Create the Update selected custom button and add the following code to the Server tab:

global $dal;
while ( $data = $button->getNextSelectedRecord() ) {
  // set ReportsTo field to 'Bob Smith'
  $sql = "Update employees set ReportsTo='Bob Smith' where KeyField=".$data["KeyField"];
   CustomQuery($sql);
}
$result["txt"] = "Records were updated.";

and to the Client After tab:

var message = result["txt"];
ctrl.setMessage(message);

The Client Before tab should be blank (delete sample code there if you have any).

See also:

•Database API

•Tri-part events

•Button object: getNextSelectedRecord()

•About SQLQuery class

•AJAX helper object: setMessage()