Description
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.