Procedures: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
==Building a Procedure==
nuBuilder Forte can create Procedures.
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.


A good example of this is where a Procedure can be used to create the [[Reports#Table|table]] used in a [[Reports|Report]].
Here are 2 examples of where a Procedure can be used.
#To create the [[Reports#Table|table]] used in a [[Reports|Report]].
#Reduce available stock in a products table after an invoice is created in nuBuilder.


Another example might be to reduce available stock after an invoice is created in nuBuilder.
===Code===
A unique Code for this Report
===Description===
The description of this Report
===Group===
A field that can be used to help organise Reports.

Revision as of 01:30, 7 July 2017

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 Report

Description

The description of this Report

Group

A field that can be used to help organise Reports.