Hash Variables: Difference between revisions
No edit summary |
No edit summary |
||
Line 3: | Line 3: | ||
In each of these situations nuBuilder does a search and replace. | In each of these situations, nuBuilder does a search and replace. | ||
With all currently available Hash Variables and any you use, before it is used. | With all currently available Hash Variables and any you use, before it is used. | ||
Line 60: | Line 60: | ||
Using Hash Variables allows you to have changing titles on [[Report_Designer#Object_Properties|Report Labels]]. | Using Hash Variables allows you to have changing titles on [[Report_Designer#Object_Properties|Report Labels]]. | ||
An example of using Hash Variables in a Report Label. | |||
<source lang="html"> | <source lang="html"> | ||
Revision as of 23:20, 28 July 2017
There are 5 places Hash Variables can be used..
In each of these situations, nuBuilder does a search and replace.
With all currently available Hash Variables and any you use, before it is used.
To find what Hash Variables are available to use, you can run nuHash() inside your code.
PHP
Hash Variables allow you to customise your PHP code.
Example of using Hash Variables in PHP. <source lang="php">
$s = "CREATE TABLE #TABLE_ID# SELECT * FROM invoice";
nuRunQuery($s);
</source>
HTML
Hash Variables allow you to customise your HTML Objects.
The Hash Variables available to HTML Objects are the same as those available on Before Edit.
Example of using Hash Variables in HTML. <source lang="html">
<iframe
width="560" height="315" src="#cus_youtube#" frameborder="0" allowfullscreen>
</iframe>
</source>
Custom SQL
All Custom SQL used in nuBuilder Forte. <source lang="sql">
CREATE TABLE #TABLE_ID# SELECT * FROM customer;
</source>
SQL Builder
Any Clause in the Clauses Subform in the SQL Builder.
<source lang="html">
= '#RECORD_ID#'
</source>
Report Labels
Using Hash Variables allows you to have changing titles on Report Labels.
An example of using Hash Variables in a Report Label. <source lang="html">
Sales Between #from_date# And #to_date#
</source>