U (WB_Command) - Update

This command is used for updating the record(s). When executed, it opens the recordset (variables WB_UID, WB_BaseName and WB_RcdSet must be defined when you use this command), changes the record(s) and displays processed WBSP page or redirects client to URL defined in WB_Redirect variable.

Important: If WBSP page with command U receives form data for more than one record, it will update all the records received. In this case WhizBase requires arrays of WBF_ fields with equal number of members (e.g. if you update 1 field for 4 records you MUST send four sets of WBF_field1 (WB_UID member) and WBF_fied2 form fields). For more info on updating more records at once please also read Multi update command. We strongly recommend you to password-protect either your database (using MS Access system.md? file) or the WBSP page containing this command (using WB_HTAccess).  WB_UID variable in WBSP page containing the UPDATE command defines the name of recordset field that has a unique value for every single record. If recordset for single WBF_UIDfieldname form field value returns more than one record the error will be generated.