I have this example that adds a row to the s01_BasketCharges table:
< mvt:assign name="l.basket_charge:basket_id" value="g.Basket:basket_id" />
< mvt:assign name="l.basket_charge:type" value="'TAX'" />
< mvt:assign name="l.basket_charge:descrip" value="'Custom Description'" />
< mvt:assign name="l.basket_charge:amount" value="g.final_tax_calulation" />
< mvt:assign name="l.basket_charge:disp_amt" value="g.final_tax_calulation" />
< mvt:assign name="l.basket_charge:tax_exempt" value="0" />
< mvt:do file="g.Module_Library_DB" name="l.ok" value="BasketCharge_Insert( l.basket_charge )" />
I would like to modify this code to insert a row into my "shipping" table.
It appears that I would set a value for each column in my table using the <mvt:assign statement where name = the column name.
but how should the mvt:do be coded? Will my table have to be added to the g.Module_Library_DB? I would guess so.
And I'm guessing that the insert function there should be named "shipping_Insert".
And how do you check the l.ok variable which I'm guessing has the result of the DB function. A 0 or 1 or ?.
What do I have to do to get a "shipping_Insert" function into the Module_Library_DB?
Can someone do that for me? I imagine it has to be compiled.
Thanks, Larry
< mvt:assign name="l.basket_charge:basket_id" value="g.Basket:basket_id" />
< mvt:assign name="l.basket_charge:type" value="'TAX'" />
< mvt:assign name="l.basket_charge:descrip" value="'Custom Description'" />
< mvt:assign name="l.basket_charge:amount" value="g.final_tax_calulation" />
< mvt:assign name="l.basket_charge:disp_amt" value="g.final_tax_calulation" />
< mvt:assign name="l.basket_charge:tax_exempt" value="0" />
< mvt:do file="g.Module_Library_DB" name="l.ok" value="BasketCharge_Insert( l.basket_charge )" />
I would like to modify this code to insert a row into my "shipping" table.
It appears that I would set a value for each column in my table using the <mvt:assign statement where name = the column name.
but how should the mvt:do be coded? Will my table have to be added to the g.Module_Library_DB? I would guess so.
And I'm guessing that the insert function there should be named "shipping_Insert".
And how do you check the l.ok variable which I'm guessing has the result of the DB function. A 0 or 1 or ?.
What do I have to do to get a "shipping_Insert" function into the Module_Library_DB?
Can someone do that for me? I imagine it has to be compiled.
Thanks, Larry
Comment