VariablesResetAll

Clears all variables that are logged with VariablesLog function

Average rating: 4.6 (28 votes) Log in to vote

Fabrice Nordmann - Show more from this author
1-more-thing
https://www.1-more-thing.com

Sample input:

no input, just variables

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
VariablesResetAll ( ) 
Fabrice Nordmann's adaptation of 

VariableDestroyAll ( )
by
Jonathan Mickelson, Thought Development Corp.
http://thought-dev.com

to work with VariableLog ( key ; value ).

remove all global variables logged in $$_VariablesLog
*/

Let ( 
[ 
// Incomming Parameters 
valsTot = ValueCount ( $$_VariablesLog ) ;
lastVal = GetValue ( $$_VariablesLog ; valsTot ) ; 

// Get Variable Name out of Last Value
var = Substitute ( LeftValues ( Substitute ( lastVal ; "|" ; "¶") ; 1 ) ; "¶" ; "") ;  

// Initialize/SetVariable to entered Value 
letTxt = "Let ( " & var & " = \"\" ; \"\" )" ; 
initialize = Evaluate ( LetTxt ) ; 


// Test if Variable already exists - Prepares result for user feedback 
$$_VariablesLog = LeftValues ( $$_VariablesLog ; valsTot - 1 ) ; 
result = Case ( WordCount ( $$_VariablesLog ) = 0 ; 1 ; 0 ) ;

// Remove Global Variable Storage if finished 
$$_VariablesLog = Case ( result = 1 ; "" ; $$_VariablesLog ) 
] ; 

Case ( result = 1; result ; VariablesResetAll )
) // END LET

use this in combination to VariablesLog ( key ; value )

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

VariablesResetAll

Comments

Support this website.

Support this website.