$WB*$

Availability
UPDATE command

Syntax
$WB*$NumericValueToBeMultipliedBy

Description
This is a form field value prefix for doing mathematical operation of multiplication 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 multiply 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="Double the price">
</form>
<!--WB_EndDetail-->
<center>$wbnavigator</center>
</body>
</html>
 

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