Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Last revision Both sides next revision
cfl_ch_3-formulas_and_functions [2019/07/15 19:28]
admin [Utility Functions] 		cfl_ch_3-formulas_and_functions [2019/07/15 19:38]
admin [SQL Functions]
Line 389: Line 389:
 |**ReturnSQLNumberValueWithWait** |SelectSQL, \\ TemporaryValue|Once the SelectSQL has finished executing, the value of the first column in the first row of records is returned. \\ If there are no records found, the TemporaryValue is returned.| |**ReturnSQLNumberValueWithWait** |SelectSQL, \\ TemporaryValue|Once the SelectSQL has finished executing, the value of the first column in the first row of records is returned. \\ If there are no records found, the TemporaryValue is returned.|
 |**ExecSQL** |SQLCommand|Executes a SQL command without a return value. Allows execution of Insert and Update commands.| |**ExecSQL** |SQLCommand|Executes a SQL command without a return value. Allows execution of Insert and Update commands.|
-|**LoadFromURL** |URL, RaiseErrorOnFailure=True, TimeOutInMS=1000|Returns the result of the URL endpoint. Triggers external events, though it could be used to load data from an API.|+|**LoadFromURL** |URL, RaiseErrorOnFailure(Optional), TimeOutInMS(Optional)|Used to trigger external events, though it could be used to load data from an API. S := LoadFromURL( string: URL, boolean: RaiseErrorOnFailure = true, int: TimeOutInMS = 1000 )|
  
 \\ \\
Line 410: Line 410:
 |**RunMacro** |MacroName, \\ ID, \\ ClassTypeID|RunMacro( MacroName : string, ID : int, ClassTypeID : int ); \\ This function executes a particular macro. \\ The **MacroName** parameter is the text name of the Macro to be executed. \\ The **ID** is the ID of the record instance passed into the Macro. \\ The **ClassTypeID** is the ClassTypeID of the record instance passed into the Macro.| |**RunMacro** |MacroName, \\ ID, \\ ClassTypeID|RunMacro( MacroName : string, ID : int, ClassTypeID : int ); \\ This function executes a particular macro. \\ The **MacroName** parameter is the text name of the Macro to be executed. \\ The **ID** is the ID of the record instance passed into the Macro. \\ The **ClassTypeID** is the ClassTypeID of the record instance passed into the Macro.|
  
-====   ====+====   Layout Specific Functions   ==== 
 + 
 +CFL has several functions are not general purpose (as those above) but specific to layout of pages and signs on a roll or sheet. Though the calculation can be (and has been) done using the general formulas, these occur so often that CFL has special functions to manage them.\\ 
 +These are complex functions that perform many calculations and set many variables. 
 + 
 +  * See [[CFL Function - CalculateLayoutOnRoll|]] 
 +  * See [[CFL Function - CalculateLayoutOnSheet|]] 
 + 
 +\\ 
  
 ===== Shipping Functions ===== ===== Shipping Functions =====