Procedures

From nuBuilderForte
Jump to navigation Jump to search

Building a Procedure

nuBuilder Forte can create Procedures.

These Procedures are written in PHP to do things to the database directly.

Here are 2 examples of where a Procedure can be used.

  1. To create the table used in a Report.
  2. 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.

  1. Click the Run Procedure Button on the Setup Tab of the Home Form.
  2. Create a Button with a custom click event to run

nuRunHiddenPHP("STK"); or nuRunPHP("STK"); (STK being the Procedure code )