$WB/$

Availability
UPDATE command

Syntax
$WB/$NumericValueToBeDividedBy

Description
This is a form field value prefix for doing mathematical operation of division with values of fields of numeric type. When WBSP engine receives a WBF_tablefieldname form field value with this prefix for database table field of numeric type, instead of replacing the old value with new one, it will divide existing value with the new value (so new value stored in the database is OldDatabaseTableFieldValue/NewFormValue)

Here's an example:

<!--
[FormFields]
WB_BaseName=biblioA.mdb
WB_RcdSet=Titles
WB_Command=Q
-->
<!--WB_BeginTemplate-->
<html>
<body>
<!--WB_BeginDetail-->
<form action="TitlesUpdate.wbsp" method="POST">
<input type="hidden" name="WBF_Price" value="$wb/$2">
<input type="hidden" name="wbf_isbn" value="$wbf[isbn]">
$wbf[Title]<br>
Current price: $wbf[Price]<br>
<input type="submit" name="sUpd" value="Reduce the price by half">
</form>
<!--WB_EndDetail-->
<center>$wbnavigator</center>
</body>
</html>
 

After running this example (and pressing the "Reduce the price by half" button), field Price in updated record of table Titles will be divided by 2.