MySQLi Delete Record

Deleting an existing record can be accomplished by using the Delete Record Server Behavior.

In the Server Behaviors panel (Window > Server Behaviors), click the plus (+) button and choose WebAssist > MySQLi > Data Management > Delete Record from the pop-up menu.

 

     

  1. Use the Trigger select list and associated Trigger Dynamic Data button to select the event in which your record will be deleted.
  • Any Form Post: Any form posted to the current page that the server behavior is applied to triggers the data insert
  • Before Page Load: The data insert is triggered when the current page that the server behavior is applied to is loaded.
  • On Form Submit: Any form submitted on the same page that the server behavior is applied to trigger the data insert.
  • Button [button name] pressed: The server behavior is triggered if the specified button on the page is clicked.
  • Dynamic Data: Server-side code can be specified in the dynamic data interface (accessed through the lightning bolt) to create a trigger specific to your needs if one in the list does not meet your requirements
  1. Use the Connection and Table menus to specify the database table that contains the record you wish to delete..
  2. Use the Lookup column menu to specify the column that will be used to locate the record being deleted. This is most often the record ID.
  3. Use the Column type menu to specify the data type of the lookup column. In most cases, this will be preset for you - However, you can select any of the following:
    • Integer
    • Text
    • Date
    • Floating point number
  4. Use the Lookup value field and associated dynamic data button to select a value that will be used to select the record you wish to delete.
  5. Use the After updating, go to field to select a page to redirect to after a successful record deletion.

 

After clicking OK, the Delete Record Server Behavior will be applied to the current page. Changes can be made by editing the MySQLi Delete Record Server Behavior from the Server Behaviors panel.