Procedures: Difference between revisions
Jump to navigation
Jump to search
Line 51: | Line 51: | ||
===After Delete=== | ===After Delete=== | ||
== | ==Lookups== | ||
===After Browse=== | ===After Browse=== |
Revision as of 04:19, 13 July 2017
nuBuilder Forte can create Procedures.
A Procedure is PHP code run to manupulate the database.
Building a Procedure
These Procedures are written in PHP to do things to the database directly.
Here are 2 examples of where a Procedure can be used.
- To create the table used in a Report.
- Reduce available stock in a products table after an invoice is created in nuBuilder.
Code
A unique Code for this Procedure
Description
The description of this Procedure
Group
A field that can be used to help organise Procedures.
Launch From
A Launch Form will allow..
- The user to define the information to be used by the Procedure.
- Run the Procedure from an Action Button at the top of the Form.
Run
- In a new window - Appears in a new window much the same as a Report.
- Hidden - This runs behind the scenes but can display a result using nuDiaplayMessage()
PHP
A Textarea containing PHP code.
To edit this, double click on the field and you will open Ace Editor in a full screen.
PHP Library
This subform allows you to add other previously created Procedures to be run when ever this Procedure is.
Running A Procedure
There are 2 ways to launch a Procedure.
- Click the Run Procedure Button on the Setup Tab of the Home Form.
- Create a Button with a custom click event to run nuRunHiddenPHP() or nuRunPHP().
Adding PHP Elsewhere
PHP can be added in different places on Forms or Lookups.