XModPro

Using command button in a form

Dana Armstrong Dana Armstrong asked Aug 21, 2017
Active Aug 23 · Viewed 2173 times
<p>I know that the command button is supposed to give you the ability to run multiple commands on multiple templates. Is it possible to run multiple UPDATE and/or INSERT queries from a form by specifying as targets the IDs of SubmitCommands in the Command tags? Do I have to try to insert templates within the forms to get this to work or can I access the SubmitCommands directly? I'm building a form which moves inventory from one area to another, so after the quantity field values are recalculated using javascript, I'd like to do two updates on existing records, or an update on one existing records and an insert of a new record. Also would need the ability to put conditional logic into the button (if the line item exists update it, if not create it). If this doesn't work, I guess I'll use a stored procedure with a single submitcommand to do the work. Just wanted to see how flexible command buttons were, and maybe get you thinking about some new features for command buttons. </p>

3 Answers

Loading answers...