Procedures: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
nuBuilder Forte can create Procedures.
A Procedure is PHP code run to manupulate the database.
=Building a Procedure=
=Building a Procedure=
nuBuilder Forte can create Procedures.


These Procedures are written in PHP to do things to the database directly.
These Procedures are written in PHP to do things to the database directly.
Line 30: Line 33:
==PHP Library==
==PHP Library==
This subform allows you to add other previously created Procedures to be run when ever this Procedure is.
This subform allows you to add other previously created Procedures to be run when ever this Procedure is.
=Running A Procedure=
=Running A Procedure=
There are 2 ways to launch a Procedure.
There are 2 ways to launch a Procedure.
#Click the '''Run Procedure''' Button on the Setup Tab of the Home Form.
#Click the '''Run Procedure''' Button on the Setup Tab of the Home Form.
#Create a Button with a custom click event to run <span title="Javascript" style="background-color:#f8dc3d;padding:2px">nuRunHiddenPHP("STK");</span> or <span title="Javascript" style="background-color:#f8dc3d;padding:2px">nuRunPHP("STK");</span> (STK being the Procedure code )
#Create a Button with a custom click event to run <span title="Javascript" style="background-color:#f8dc3d;padding:2px">nuRunHiddenPHP("STK");</span> or <span title="Javascript" style="background-color:#f8dc3d;padding:2px">nuRunPHP("STK");</span> (STK being the Procedure code )

Revision as of 04:05, 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.

  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 )